Still, it looks like single string assignment cannot be longer than 8000 characters. To work around this, split your long sql string into parts and use + operator to put...

Can you give us more information? Can you reproduce the problem? If so, please enable trace flag 1222 and see what is the output. What do you read any data...

Hi,

I am not sure if you have solved your problem yet, but here's what I think about it.

Look at the debugging on a production database from business point of...

It may be worth to mention also that varchar(2) is a bad design choice. because in fact up to 4 bytes are required to store the value.

Regards

Piotr

Well, if the database is offline you can't connect to it, so why would you want to write anything to it?

Regards

Piotr

This is an old post, I wonder how this was (if at all) resolved.

If not, can you post the MEMPOFF table DDL? I just wonder, if creating NC covering index...

You are right, dropping indexes may speed up the bulk insert operation. This depends on the number of rows in the table the rows are inserted to and the number...

If there was clustered primary key on email, it could have been lagging due to page splits during inserts. I think in this case a nonclustered unique constraint (to ensure...

Oh yes, this script only reflects requirements specified by OP. You can definitely taylor it to suit your needs.

Regards

Piotr

I have these two little queries in my templates:

--select all roles for given user

select user_name(role_principal_id), user_name(member_principal_id) from sys.database_role_members

where user_name(member_principal_id) = 'user name'

--select all role members for given role

select user_name(role_principal_id), user_name(member_principal_id)...

Name is logical file name in this table, not the database name. Check this out:

SELECT db_name(database_id) [Database name], Name [Logical file name], Physical_Name [Physical file], size*8 [Size_KB] FROM sys.master_files

where...

I like to write scripts that generate scripts to execute. Please switch SSMS into text mode results and have a look this:

To generate script that will detach databases you can...

Do they prevent file from being loaded? If not, I guess you can use conditional split to separate them from the rest of the rows.

Regards

Piotr

I guess the whole application here will become too complicated for the problem that you have anilp.

What I would see here is single database with tables that would keep...

Jim, what would happen if you put the final select to another stored procedure and passed these retrieved dates as parameters to it?

create procedure innerProc(datetime @start, datetime @stop)

as

SELECT col1,col2,col3

FROM tableA

INNER...