Also make sure you are not using dynamic SQL and that all objects are owned by dbo.

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

Steve that setting is only the listening port not the actual port that communicatrion with connected clients takes place on.

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

I agree with Andy, NT Accounts would be better for you as you can then use trusted connections as long as they log intot the Domain or Server when they...

Explicitly trying to set the value of an Identity column is not allowed unless you use SET IDENTITY_INSERT ON or turn OFF the identity setting for the column then ON...

What are you servers regional settings for dates and what language is the SQL Server using. If not MM/DD/YYYY as default it may not understand that format. Add

SET DATEFORMAT mdy

to...

Also IN is easier to read. And depending on the needs of the query and the number of items in your IN it may build an internal constants table that...

No but I beleive IE 5+ has it, plus there is a seperate download available somewhere on the sight.

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

The last statement should work but you have to check the execution plan to make sure it does not cause an issue. I prefer Steves idea as the point of...

Yeah with SQL7 your limited to a trigger or stored procedure. A trigger is though your best bet as direct insterts will be handled as well.

Do it based on FOR...

You you can still use this technique as long as you plan properly. Try

exec('create table #t1 (ident int)

select * from #t1')

This should work and all run under the same context...

Love this feature and I love TV Out cards. I have an ATI AllInWOnder I have had for 3 years and never tire of all I can do, but can't...

Wonderfull trip down the lane. Things have changed a lot and most have gotten better and yes some worse (bad programmers should be forced to rewrite their bad apps).

"Don't roll...

This is a statement from the whitepaper on failover clusters found at http://www.microsoft.com/sql/techinfo/administration/2000/failovercluster.asp. But the fact is each node has server installed but left in a wait state.

With instances, come...

If you decide to test keep in mind SQL stores data in 8k pages so it is best if you keep the value a multiple of 8.

"Don't roll your eyes...

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)