Viewing 15 topics - 246,046 through 246,060 (of 283,968 total)
Topics
Started by
Posts
Last post
I have setup a Transactional Publication with Pull subscriptions. The server is Sql Server 200…
2 replies
how do i display scientific notation and limit the # of dec places displayed. i what to have only (…
1 replies
I get this error: "This SQL Server has been optimized for 8 concurrent queries. This limit has been…
9 replies
I see the option to "Keep NULLS" in the Transform Data Task Properties, but it does not work. Is th…
8 replies
For what is used the modifier N' sometimes before the variable in Store Procedures. For Exam…
18 replies
This is one row from an excel spreadsheet. I want the first 5 items in the row to go to table 1 and…
7 replies
Hey all, I know creating an Alert for SQLAgent shutdown/restarts will not work. Besides using 3rd …
3 replies
I need to replace certain characters in a string before inserting into a table. I would like a func…
19 replies
I put SQL in single user mode, opened another cmd prompt with e:\mssql7\backup isql -U sa typed in …
4 replies
Our network team is upgrading NT domain controller to 2003. Our sql servers are also part of that d…
3 replies
Does anyone know the reason why I am getting 5105 error when I try to attach a adatabase on a diffe…
3 replies
How I Can use the Field Name of Table as a Parameter without use: Exec ('Select * from Table_Name w…
3 replies
I would like to have a variable (parameter) used as the ENTIRE where statement in a Proc. Somethin…
1 replies
I need to trace some deadlocks we are having on Production SQL servers and I have …
2 replies
I want to generate dynamic sql for @sqlstr ='USE <databasename> GO' i am entering the databas…
7 replies
Viewing 15 topics - 246,046 through 246,060 (of 283,968 total)