That option is not in SQL 2005 Management Studio. You can right click and seelct open or you can right click and select to script as a select, update, insert,...

Well, first of all, response.write is not valid in a .vbs file. Are you sure you didn't take that from ASP code?

ANSI_Padding controls how data is stored, not how it is inserted. So setting ANSI_Padding off in SQL Server has no effect whatsoever on how Access stores it. You need to...

Try rebooring the server. I've found that when there are problems authenticating a Windows login and SQL Server is claiming that the user is Null or unknown, then rebooting the...

Int's CAN be replicated!!! Even if it is an identity field, it can still be replicated!!!!

In SQL 2005, there is a new function for generating sequential uniqueidentifiers....

Rarely have I disagreed more with an article I've read on here.

What we have done in the past is to have a database that we called ThirdParty in dev/test/produciton. When we have a data source (from customer, third party vendor, etc.) that...

I would be opposed to all of these solutions. Production and test should remain separated entities. If you do a direct import of any kind from test into production, you...

Please don't post the same question in multiple forums. It's been answered in another forum already.

http://www.asp101.com has easy to follow tutorials on how to do this. Just go to the samples section.

You can reference the SQL Server connection as being (local), and it will always refer to the machine on which it is being run. Doing it this way, however, means...

Since you are using SQL 2005, you should just use the SQL 2005 view and forget about the SQL 2000 compatibility view.

Select

*

From

Or to use the SQL 2005 sys view, simply look at the is_user_defined column of the sys.types view. From Books online:

Try running this instead:

select bucketid, cacheobjtype, objtype, objid, dbid     

 from master.dbo.SYSCACHEOBJECTS with(nolock)

 where  objid = 1718297181

Because it isn't cached.