Viewing 15 topics - 275,611 through 275,625 (of 283,968 total)
Topics
Started by
Posts
Last post
Can you create an index on a view using SQL Server 2000 Standard edition? If so, how?
10 replies
By: kirbles
Years ago I had a sniffer package that showed me all the trafic between my PC and the SQL Server bu…
4 replies
By: hoodg
CREATE TABLE [conflict_jlinknew1_Accounting] ( [ID] [int] NOT NULL , [Username] [varchar] (100) C…
3 replies
I was wondering if anyone has had any experience with developing and implementing any means of lock…
5 replies
By: spireite
Hi, I don't understand why this work in my stored procedure SELECT database_name, SUM(CASE(DATEPART…
1 replies
Have hit a bit of stumbler with respect to @@IDENTITY. After an insert into a table I always want t…
6 replies
When attempting to view the database security of our SMS_CS1 database, I noticed that their was a u…
3 replies
In 6.5 i could raiseerror and the message will be logged into the task history. How do i accomplish…
9 replies
I was looking at the Kevin Kline's "Analyzing and Optimizing T-SQL Query Performance on Microsoft S…
2 replies
By: mgeiser
Hello, I need to delete records from a table that match the results of the following query: *******…
2 replies
By: cdun2
Setting a procedure as Autoexec (using sp_procoption) makes SQL run it at startup, but it does not …
1 replies
You may learn the syntax of SELECT statement and expand skills by means of executing the exercises …
2 replies
By: richsera
Under SQL 2000, how do I adjust to amount of memory used by Full Text Search ? I'm getting a perfor…
2 replies
Hi All, Using the DTS designer, i tried an ActiveX script using DTSLookups, it fails with the messa…
1 replies
By: jfb
I have the following code in an ActiveX task in SQL Server 2000 DTS. This code sets the cube proces…
2 replies
By: mhweiss
Viewing 15 topics - 275,611 through 275,625 (of 283,968 total)