I'm not sure if I understand the question correctly, but when the SQL Server service is running, it locks the physical files so that no one can delete/alter the files...

I remember once coming across a similar problem when I used functions in where clauses.

If I remember correctly (it was a long time ago) I needed to convert the parameter...

Thanks. I've gone with the option of saving the file as a csv and then importing that.

If I get some more time, I will try some of the other...

When I use preview to look at the data, the numeric data is missing. The first row is column headers, the second row has a character value in this...

I'm inclined to agree that just storing the data I have is the better option than creating data.

The values I might have created would be the current value not the...

I don't like bit values because I can never remember what the values stand for (or is it I can never remember what the values stand for because I never...

I use global temp tables but I always put in a unique qualifier (e.g. spid) in the name of the table to prevent one user tripping over another.

Jeremy

Frank,

This came up in a thread a few weeks ago but I still don't know why the space used goes screwy. Do you?

Jeremy

Try running DBCC UPDATEUSAGE in QA for the database in question. It updates the space used displayed in EM. I have had problems with zero space which have...

Take out the GO separator:

create procedure batch_queries as

select *

from table_a

select *

from table_b

select *

from table_c

Jeremy

Somthing like this would do the trick:

create #temptable

( <column definitions> )

insert #temptable

exec [database_name].[object_owner].[stored_proc_name] <parmlist>

drop table #temptable

If the second database is on a different server then all you...

Have you considered net stop and net start commands?

Jeremy

Frank,

Just quick of the blocks this time.

Jeremy

You would need to use dynamic SQL to do this.

declare @sqlstring nvarchar(1000)

set @sqlstring = N'select * from ' + @DBName

exec sp_executesql @sqlstring

You might need to set SELECT permission on the...

The only permission I give the users is SELECT permission on the database tables and, of course, execute permission on the stored procedure they call from the client app. ...