Odd... went into Visual Studio 2005 and then back into SSMS and now the dialog box is gone. Seems like a bug.

If you're running on Windows Server 2003, you'll need to set up DTC for network access. If you recently applied SP1 for Windows Server 2003, realize that even if you...

I'm in the same boat. Enjoy it when I have the time, but it's been almost a year since I've played. Even that was intermittent at best.

It depends... if the application can use a file DSN, yes you can. There you can edit the file containing the connection information. However, if the application reads only a...

Users are connecting to the web server on the dev box using Windows authentication. That's one "hop." Therefore, when the SQL Server also lives on the same box, in this...

Oddly enough, writing. I write ministry materials for Children's Church and men's ministry for the church I serve as children's minister for (SouthEast Community Church in Columbia, SC). I also...

All columns exist. The inserted tablespace shows up on INSERT and UPDATE operations. It contains the rowsets that are changing as they would be AFTER the operation. The deleted tablespace...

The code Carl posted will handle all values of ID just fine if you're only inserting one row at a time. If you just don't want 0 values to insert,...

That means your SQL Server is in Windows authentication only mode (not mixed mode). You can make a registry setting change to switch it to mixed mode and restart SQL...

According to the Microsoft support professionals in this thread:

SQL 2000 AD Forum (@ dbforums)

There are two files to replace:

xpadsi.exe

sqladhlp.exe

Failing that, I would call Microsoft Support. It...

Agreed. Virtual machines bearing SQL Servers need to be tuned according to the parameters provided by the virtualization software. This isn't all that different from what should be done with...

The SQL Server 2005 development and testing cycle differeed greatly from previous cycles. Keep in mind that not only were there rounds of beta testing, but Microsoft developed the Community...

There are so many things that have been improved a forum post won't do it justice. Just on the security side, some of the important changes:

• User-Schema Separation
• Security Context Switching
• No direct...

The job is going to execute under 1 of 2 contexts. If it's owned by sa or a member of the sysadmin fixed server role, it's going to execute as...

Use an else statement and perform the update again. The reason you need to do this is the INSTEAD OF trigger fires before the data operation in the event that...