Tag | SQL Server Posts

You may receive the error "This document already has a DocumentElement node." while trying to read XML Data retrieved using the FOR XML clause.SQL Server 2000's FOR XML Clause provides great support in querying SQL Server Data and retrieving it in the form of XML. In other words, you can get an XML representation of the Result Set using the FOR XML Clause.So, if a select statement of select * from customers retrieves results in a sequential way, select * from customers FOR XML AUTO will retrieve ...
Seems I missed the excitement of the power outage today; the cabbie relayed the story to me as we creeped up I405, feeling the after-affects of the heavy congestion that was only worsened by the lack of traffic signals. Unfortunately I had to reserve the my room at the hotel that is the further from the Convention Center, but that Sheraton Universal City is treating me well (better than Scoble at the Westin, it seems, but not as good as Casey Chesnut from the Channel 9 crew). I'm posting the my schedule ...
I opened IE7 a few minutes ago and was notified that Microsoft Update is now available. This new service replaces Windows Update and adds patching for Office, Exchange and SQL Server all in one place. Microsoft intends to add more if not all of their applications to the list. I hope Microsoft will make it easy for other applications to tie into this service so we can have one update service for all of our software. And of course ti should be free ;) For more information visit http://update.microsoft.com ...
Like all good computer geeks, I try to download and trial all of the latest and greatest versions of software as soon as it is made available by the great geek god MiSDeN (may his code always compile). Vista was no exception. At 2.4 GB, even over a broadband connection the download took several hours. Finally got the ISO, burned to a DVD and installed on a separate partition (of course). After I finally got it up and running, started to play around with it. My goal was to put all of my beta’s ...
After reading several good things regarding Subversion and TortoiseSVN I decided to give it a try. The “final straw” came while looking into Ajax.NET which is housed in SVN and required installing TortoiseSVN to obtain the source. The process was so smooth and easy I decided it was worth a shot. The scm options facing my little company are very typical: Continue using VSS with it's warts - extremely slow client, requires either VPN access to servers in office or a 3rd party product such ...
I've uploaded Beta 2 of the BizTalk Peformance Tester (yes, I've changed the name) to GotDotNet. This release fixes the following reported bugs: Added configuration menu item to support post-install configuration changes via the UI Fixed bug in configuration UI where the delete timer value was being misrepresented Updated the documentation with a run-time screenshot of the configuration dialog Scripted the creation of the required SQL Server database during installation Please uninstall the previous ...
I just read Bill Evjen's Learn ASP.NET Page, and it has a lot of good information you should check out. For some reason the comments on his page were not working. I couldn't get anything to post. So, here is a quick blast of items that I have stored in Yahoo! MyWeb related to .NET 2.0 Books There are not a lot of books out yet, but if you are familiar with ASP.NET already, check out ASP.NET 2.0: A Developer's Notebook. I leave it sitting on my Safari Bookshelf. They also publish a Visual Basic and ...
So what could be better than going to Las Vegas to geek out for a week? NOTHING YOU FREAK!! As you may have heard that there is a little product launch in November from Microsoft releasing VS2005. It shouldn't be that big of deal. Get a few people together and a keg and the next thing you know you have a DevConnections Conference. :) Actually, the truth is that ASP.NET DevConnections is got a very nice line up for their conference in Las Vegas. They have lined up some really great speakers and some ...
Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group on this server The devil is always in the details J The following I wanted to share because this individual sorted through this error and his resolution may help someone else. I am posting a summary of our correspondence. PROBLEM: BizTalk Deployment Failing – Error: Unable to connect to registry on the server (machineName), or you are not a member of the OLAP Administrators group ...
ugh. i'm really wishing that sql server 2000 dts package execution had a "start and run from this step" type of deal. I have this huge package (hehehe......sigh) and when it crashes in the midst of it, i'd like to be able to correct the sql/activex script and then resume it. but nope. i gotta execute each step individually if i want to continue down the road. otherwise i'd have to start the show over. unfortunately, this show runs about 3 hours, so i'm not really up for that....also...when you execute ...
Back in 2004 I wrote a small command prompt utility, called SqlDoc, to document SQL Server databases. I posted that tool to CodeProject. I wrote it for my own use and soon I found it extremely useful. The idea of improve that tool and even transform it to a commercial product was rounding my head for a long time. This summer I've spent many hours to make that idea a reality, and it's finally here: dbdesc v.1.0 Some differentiating features with the rest of commercial products out there are: It uses ...
So you wanna use Sql Server 2000 DTS to go out and pull down some files via an Ftp site? Simple right? Well what if your vendor is using dated filenames (i.e. 050805.zip)? not so simple anymore. i had a really hard time finding information on todays task and i'm passing the solution on to others: 1. Create your new DTS package.2. Drag an FTP Task on the package. 3. Enter in the Non-changing static information on the first tab (ftp site, username, password and dump location) - Dont select any files ...

From Scott Gu's Blog:

One question I’ve seen asked a few times by people over the last few weeks is “how do I setup the new ASP.NET Membership, Role Management, and Personalization services to use a regular SQL Server instead of SQL Express?” This blog entry walks you though a few simple steps on how to-do this.

Deploying BizTalk Server 2004 - Complete / Clustered - Production Setup (NOTE: If you find any errors here - please feel free to point them out - I worked hard to document each step and leave nothing out. Some of the steps that are not detailed are so because the process is pretty straight-foward.) This document takes the following considerations into account. Please note: You need to be familiar with basic network naming conventions for this setup. Before beginning the processes to setup BizTalk ...

Most of the time, we end up using Crystal (shudder) or SQL Server Reporting services, but this might be a good alternative for simple reports.

 

Just wrote a very quick and dirty utility to allow a SELECT from a SQL Server database and save to CSV. It was for a one off data extraction for a client for a query not currently in the main web based application. Due to using MSDE there are no SQL client tools to use to do this job, and I didn't have the MSDE manager at hand. Anyway full details and source code for the utility are now at http://codecorner.tigernews... ...
Microsoft has an a KB article HOW TO: Author MSDE 2000 Setup Packages by Using Visual Studio .NET that described how to create own Setup. Our company uses this approach and now have problems with applying SQL Server 2000 SP4. The latest advice from MS - The Setup utilities for new applications must be written to call the MSDE 2000 Setup utility rather than directly consuming the MSDE 2000 merge modules. More details about disadvanages of using Merge Modules are on page Using SQL Server Desktop Engine ...
Let’s talk more about SQL Server 2005 new stuff! As before I will keep it short and sweet. I won't go into depth of what can be done with these commands because I think I would bored you, but I just want to give you a hint of what I've found cool. The OUTPUT clause IMHO is a great time saver. The one thing I do with an insert stored procedure is to return the new key ID. Now, I haven’t been all that happy with using statements such as … SELECT MAX(tableID) From DavesTable … ...
Whilst on the subject of SQL Server 2005, I wanted to just talk about a new feature that is coming in the new SQL Server Mobile Edition that I’m excited about. Well you know when you can run .Net code on a mobile device from the Visual Studio IDE? Well in the new version of SQL Server Mobile Edition and SQL Server 2005 you will be able to run SQL on the device from the SQL Server Management Studio! Big deal!? Well yes if you have tried to use the SQL editor on a PDA which is so painful typing ...
I know I don’t often talk about code, but I have recently had the good fortune to get back into playing around with the new version of SQL Server 2005. I think I’m going to do a few small posts on some of the new things I’ve found that I like. Insert and Merge, finally your can ‘Upsert’! Upsert is a mythical feature where you can insert and update data with one command. It's not quite in one command but the effect is the same with a simple set of syntax. MERGE INTO DavesTable USING DavesTempTable ...
Via Ed Bott, Dwight Silverman wants to know what's on your start menu.No, not what programs you have installed. He wants to know what your top 6 programs are that you use - you know, in Windows XP, the left side of the start menu, where it has an MRU program list.I'm game. Here's my two lists. The first one is on my base machine - where I don't do any development. Here's my list:1. Excel - This is unfair. I recently had a small project working on an excel sheet. No need for a dedicated VPC just to ...
I think I should put a few things straight before people get the wrong idea about the problem I was having with the CEDB in CE 4.2. Please read below. Apologies if there were any misunderstandings. A very helpful Microsoft person has pointed out that I have made a few mistakes on what I have written so here's to putting it right. 1. CEDB is not SQL Server CE. This I do know and I have tried to keep seperate. The current issue with CEDB does not apply to SQL CE at all since it uses a different engine. ...
This may be something you all know, but I keep coming across developers who don't know that it is really easy to hide system tables and stored procedures in SQL Server Enterprise Manager. Step 1 - Highlight the server in SQL Server Enterprise Manager, right click and select Edit SQL Server Registration properties... from the pop-up menu. Step 2 - In the Registered SQL Server Properties dialogue box, remove the tick from Show system databases and system objects. This will only hide the system objects ...
Upon clicking on the SQL Server Enterprise Manager shortcut the following error occurs: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC.This may be because the file does not exist, is not an MMC console, or was created by a later version of MMC. This may also be because you do not have sufficient access rights to the file. The msc file did exist and I definately has permissions to it. So I can only assume it some how got corrupt. The ...
Here is a nice simple question for someone who has been playing with VS 2005 with SQL Server 2000. Is Visual Studio 2005 backwardly compatible with the old SQL Server 2000 stuff? Basically we have a large quantity of data on SQL Server 2000 and the source feeding this at the moment is on the old 1.1 framework. We are considering upgrading to 2.0 but we aren't ready at this time to upgrade the server, hence wishing to use it with SQL Server 2000. Any advice or feedback would be appreciated ...
Just a quick question for anyone using SQLite. Is there any way of merge replicating the SQLite databases over to SQL Server? The reason I ask this odd question is that we already have a large quantity of data on an SQL Server and it is a rather complex database which could not run on SQLite. We have data in SQLite on a Windows CE platform that we wish to transfer to the SQL Server database system to populate multiple SQLite data... How can we do this? I did wonder if there was some clever way of ...

Ron Talmage has written a great article on one of the best benefits of adding the CLR to SQL Server 2005’s T-SQL implementation.

Using TRY/CATCH to Resolve Deadlocks in SQL Server 2005

Dave Hayden does it again.  This is good stuff.

Query Analyzer - Sql Server Database Indexes and Execution Plans

In todays world of EAI (Enterprise Application Integration) and SO (Service Orientation) its very important to understand integrating technologies and tools that are made available to us. I always say that todays is the information world that can be thought of applications as an islands automated within themselves but not usually connected to others. And to connect them is "the task". Sooner or later our most of efforts and development time would be consumed in either integrating applications or ...
I have an application that connects to the database on startup. This afternoon while trying to bring it up on a test machine, I ran into a funky problem. After modifying the database connection string, I got a SQL server not available message. I went, huh? Thinking it must have been some cached stuff, I hit refresh on the browser - VOILA! the login page comes up. Then, I try to log in - it combs out with a connection error. I tried this several times with different DB servers and each time the same ...
Ok, this is my first post, so I'm still trying to figure out what am I going to write and how to organize my thoughts. I figure you just have to start doing it... I want to talk mostly about building a website and all the challenges that involve doing it. I started doing the site as a hobby a year and a half ago, while I was working on the road for months at a time, and as a way of getting more practice using ASP.net. The website is called tripspotting.com, and it's a photography community. I like ...
Downloaded the SQL Server 2005 June CTP from MSDN over the weekend to install with VS.NET 2005 Beta 2 on a clean XP Pro o/s. As it the June CTP downloaded I installed VS.NET 2005 beta 2 which I already had ready. My mistake. You must install SQL Server 2005 June CTP first as the setup will refuse to run if it detects VS.NET 2005 Beta 2. A lot of uninstalling (about 10 items in add/remove programs) and it's working fine. Now I can find out if VS.NET 2005 and subversion (an open source, source code ...
Well....I just came back from my vacation, and in the first week back I found out about 3 great websites launching. Our Canadian developers (or developers anywhare) will be very happy to have these resources available to them MSDN - Vista Developer Center at http://msdn.microsoft.com/w... The site reflects a new design based on the Windows Vista look and feel. It hosts nine new technical articles that describe all the developer innovations in Windows Vista Codezone (www.codezone.com)) Codezone ...
I am by no means a SQL expert but due to the life of a network engineer I get to see a little of everything. If anyone has any suggestions or comments on the steps I used feel free to make them. Recently we had an issue with a client that there master database was corrupt and MSSQL would not start. We had an old backup of the master database and the .mdf and .ldf of the client databases only. Below I have listed out the steps we took to recover the master database and the client databases.- We started ...
The Indigo Roadshow is coming to Columbus! This is going to be a great opportunity to hear and see more about the product directly from the product group. The .NET Developers Group of Central Ohio and the Central Ohio SQL Server SIG are hosting this special event. And this event is free! You’ve heard the buzz about Indigo, Microsoft’s unified programming model for building distributed applications. Attend a FREE event and learn how Indigo technology will simplify your life. With Indigo, ...
http://www.msc.com.my/updat... There are 7 big big project planned by government of Malaysia -Electronic Government -Multipurpose Card -Smart School -Telehealth (I'm part of it, currently striving to get UAT)-R&D Cluster -Technopreneur Development -E-Business I've been part of it in Telehealth application. I have been heard of it since I was in highschool. I think half of the project have been completed such as MyKad (smartcard application for all Malaysian) and Technopreneur Development. ...

My CreateNewUserWizard start complaining about couldn't find the right parameter

I solve this by re-running asp.net sql server setup wizard. You can find this article helpful with asp.net sql server setup wizard:

http://www.kdkeys.net/forums/4135/ShowPost.aspx

The short answer to my question is “don’t have them.” Unfortunately, that’s not always a viable answer. Why is this an issue anyway? SQL Server 2000’s DATETIME field isn’t as precise as the data generated by Windows. What this means is that if you store a DATETIME and then retrieve it and compare it to the original value, the values are likely to be different. I’ve written scripts in SQL server and in .NET to compare DATETIME fields to within a hundredth ...
According to Computer Weekly Microsoft is getting the production line rolling with the RTM version of "System Centre Data Protection Manager" I have been looking at this product for use within my company as it allows remote sites, which we have a lot of, to back up to the datacenter over the WAN links. You might think bandwidth restrictions would make this a nightmare but the clever bit about DPM is that it works at the block level and only transfers the changed blocks back to the datacenter. The ...
Sorry I haven't been very active lately. This is probably the single most thing that I've been waiting for in 2005.Its the word that the beta for BizTalk 2006 (a.k.a Rolling Thunder) is going to be available soon. I cannot wait. I am already very impressed by the recent release of the SharePoint Adapter (Version 2). Since the SharePointAdapter (Version 1) is something I have great experience in, I was very pleased with the changes that were made.Here's a little summary: 1. Support for multiple endpoints ...
Free (for 90 days) e-learning courses from Microsoft to get you prepared for SQL Server 2005. 
Well, I've finally joined the blogging community. I'll try to restrict comments to useful information but I'm relying on you guys to let me know if I ramble on too much. Starting this blog is aimed to coincide with the release into the open source community of a rapid database development system for .NET which I have worked on over the past year. The goal is to provide generic database access to SQL Server 2000, MySql, IBM DB2, Oracle, Access MDB and SQL Server CE, complete with code generation in ...
I've been busy finishing up the end of FY05 at Microsoft - we had several conferences including a very successful Visual Studio 2005 Developers Conference in our region. I was also busy getting some swag together for the user groups that I support. That was fun! Now, I'm planning for the next year and starting to execute on some of it. Here's some presentations that I have scheduled. If you are in the area for any of these presentations, please attend and say hello! Introduction to ASP.NET 2.0Great ...
Monday July 11th, Don delivered a great presentation on SQL Server 2005 - Developer Security at the CRINETA user group meeting. At the beginning I gave him a hard time about the fact that he wasn't going to present at the HDC05 in Cedar Rapids this year. During the meeting he discussed schemas, synonyms, impersonation permissions, encryption, etc. After Don's presention, the CRINETA officers treated Don to a night out in Cedar Rapids. We met at the Irish Democrat for drinks and those fabulous cheese ...
Via Andrew Connell Blog MCMS 2002 Service Pack 2 will have the support for ASP.Net 2.0 though there will still be some New features that will not be supported or fully suported by MCMS running under ASp.Net 2.0 framework for example Web Parts ... MCMS 2002 Service Pack 2: Expect this to be released after the .NET 2.0 Framwork is released (BTW: today’s keynote at TechEd announced that Visual Studio .Net 2005 and SQL Server 2005 will be released to manufacturing [RTM] the week of November 7, ...
Whether you are interested in database administration, database development, or business intelligence, you can access the E-Learning topic you want, when you want it, and learn at your own pace. Each lesson includes hands-on virtual labs and offline functionality, so sign on today.In addition, you may consider taking a free Microsoft Skills Assessment to help you meet your Microsoft SQL Server 2005 training goals. You'll receive a learning roadmap with additional skills resources including instructor-led ...
All of us who write web application enforce some mechanism by which we store a user's information for the period he is accessing the application. This may be from simply storing the User's ID to say a Welcome <username> to maintaining his preferences, shopping cart etc., So far, the Session object has been pretty useful to accomplish this task. With Whidbey (ASP.NET 2.0), there is a new feature Profile which allows us to store per-user settings to be used throughout the application. Settings ...
[Download] The Microsoft SQL Server Report Pack for Microsoft Office SharePoint Portal Server 2003 is a set of 8 Microsoft SQL Server 2000 Reporting Services reports that work with a sample database of information extracted from a SharePoint Portal Server environment. This database can be populated from your own SharePoint Portal Server environment using the downloadable Data Extraction Program (DEP). The DEP will read the SharePoint Portal Server data via the object model. You also can use the sample ...
It’s been a little quiet on the blog of late for good reason. At work this product has been keeping me busy. Unfortunately because of corporate communication policy I cannot tell you how or where we are using it. Some of you in the Enterprise space may have heard of Barloworld, for those of you who haven't it's the market leader in the inventory management space and will soon be migrating from Delphi to a full .Net product, which isn't common knowledge. Barloworld have a strong open-source ...
Hi, I'm not a computer hardware specialist, but there's something that has always stricked me, since my first day on a personal computer... Why does copying of files so expensive ? Well, maybe not today with zooming cpus, motherboards, ram and hard disk, but bare with me... Imagine that the hard disk was built as a server. Maybe have it's own OS, cpu and ram. “Hey Hard Disk, this guy up there wants you to copy the file f from location a to location b. And while you're working, send me your ...