Viewing 15 topics - 278,641 through 278,655 (of 281,327 total)
I was wondering if there is an easier way to move logins and thier users from sqlserver 6.5 to 2000…
21 years, 9 months ago
By: Andy Warren
Can anyone explain the scope of SCOPE_IDENTITY() within a stored procedure...
What if two seperate …
I am a new sql server dba. I was given the assignment to setup auditing of modification of password…
We are using SQL Server 2000 as our database and Visual Foxpro as our application. In som…
In: Performance Tuning
I have been experiencing inconsistent "Script out of Range" errors in Enterprise Manager when selec…
Hello, I´m new at this and I´m not sure about if I´ll do it correctly.
I have this problem:
Hi, I'm sure this is an easy one...
I'd like to get the correct T-SQL syntax for selecting the data…
When users attempt to connect to a web application with a SQL-Server back end,they are receiving th…
If an entire SELECT statement is wrapped inside an isnull function, does this negate the use of any…
I have a DTS Package updating Table A everyday. I need to be able to query Table B for a certain re…
Has anyone any idea if Microsoft, in their infinite wisdom, has any plans to give the SQL Server pr…
I just restored the backup for one of the databases from Tape to one another harddisk…
By: Steve Jones - SSC Editor
Hi, I'm trying to rationalise some of my proceedures and I want to consolidate some case statements…
How do I specify a .txt file via http?
thanks for your hel…
In: Data Transformation Services (DTS)
I am trying to tune a large query and am seeing several Index Spool/Eager Spool objects in showplan…