Duplicate post. See http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=3410&FORUM_ID=5&CAT_ID=1&Topic_Title=Import+data+from+CLMS+to+SQL+Server+7&Forum_Title=Administration to post messages.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Should be able to use the Import Wizard in SQL as long as you have at least an ODBC connector for the database. Will this be ongoing often?

"Don't roll your...

You could try something like this.

EXEC sp_MSForEachDB '

If ''?'' NOT IN (''master'',''msdb'',''model'',''tempdb'')

BEGIN

USE ? /* Note put ? inside [] to handle odd characters, forum code kept change to

MS uses Overlapped IO Ports to handle connections in SQL as it does with IIS. There to my knwoledge is no way to specify a range and it is actually...

Could be an MDAC issue, VB SP issue. Check the event viewer and it may have more details. Also may want to get a snapshot of the memory and running...

dbo is the only understood owener reference. When an object is not owned by dbo you must qualify it by ading the ownername. before the object and it login does...

Yes QA will be the best place to view these quickly, oherwise you have to capture the return error in code or print message.

"Don't roll your eyes at me. I...

Try this

CREATE TRIGGER trWhatever ON tblWhatever FOR INSERT, UPDATE, DELETE

AS

If conditiontomeet

BEGIN

RAISERROR('Yes',16,-1)

RETURN

END

ELSE

BEGIN

RAISERROR('No',16,-1)

RETURN

END

Should return one or the other to be sure what is occurring.

"Don't roll your eyes at me. I will tape...

This is a duplicate post. Please see other thread at http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=3399&FORUM_ID=9&CAT_ID=1&Topic_Title=Insert++slows+down+due+to+Clustered+Index&Forum_Title=General for posting.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

The problem isn't the clustered index. The problem is the pages filling up. When this occurrs page splits occurr and data has to be moved to make room. Thus if...

Yes, that should be right. You essentially are setting the parentid = to the last records issue_id, but due to other transactions it could possible not happen that way (I...

Your best bet is to check with Veritas. However when the name of a server differs from that SQL has stored it usually will not corrupt. I personally do straight...

This is the reason I resorted to scripts. But it may have something to do with what SP level your running, what is your SP level and have you checked...

Basics is as Andy says, here however is an example.

SELECT * FROM tblX WITH (HOLDLOCK TABLOCKX)

But I too question why.

"Don't roll your eyes at me. I will tape them in...

That is because the variable does not exist in the same scope as the dynamic SQL query. And then this comes from BOL

A table variable behaves like a local...