Just to make it more fun, we have a third level.

As a development team own our database servers (Dev and Prod) and have admin rights on them. On the servers,...

This link http://support.microsoft.com/kb/248241 might be useful. You could possible then copy bcp across as well and it might run on your non SQL Server.

When we were trying to find out whether a database was still being used a while ago, not having been able to contact the owner of it, we reached the...

We suddenly got caught out by this last year. Having had a Stored Procedure in production for best part of a year, usually running in a few seconds, it started...

You could try changing the datatype to nvarchar and the insert statement to

insert into [testtable] values (1, N'test')

Check out Microsoft KB article 326613. It tells you which DLLs from SQL Server to package up into an MSI for distribution.

Hmmm. Sneaky!

I was sure of my answer in this (The table is created as dbo.MySecond and the grant and select complete successfully), as I am in the same situation. I...

After a lot of fiddling, I found the answer myself:

It appears that a String Variable starts to have odd behaviour during lots of concatenation operations once it gets past 4096...

This stored procedure goes slightly further by enabling a program to query the log space used easily:

CREATE PROCEDURE dbo.DBO_LogSpace

as

declare @x int

set nocount on

if exists (select *...

Again, a very useful article.

One thing which may be of use:

If you use WScript.Echo in aVBS file, then when the script is run by double clicking, then you get a...

Using Enterprise Manager (or whatever), script a table to file. This gives something like:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[your_table_name]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

BEGIN

    --Your code...

Some suggestions:

1) Check to see if the reader has any rows:

      if userData.HasRows then

2) Perform a specific conversion

      data_User_ID = userData.GetInt32(0)

I generally get my data using...

You need to add a linked server reference (sp_addlinkedserver), possibly with a login (sp_addlinkedserverlogin) when you are not using Windows Authentication.

Then reference the remote database using:

server.database.schema.object.

When querying a remote SQL...

That's a bit brutal; just kicking them out without any warning is a little unfair and not going to do much for your popularity.

I have a system which runs a...

Hmmm. All very well, but as a developer, I don't have access to luxuries such as debugging and tracing / profiling. Our DBAs just don't allow it.

At a push, they will run...