Topics
Started by
Posts
Last post
Hi its only the following bit where I am struggling exec @rc = sp_trace_create @TraceID output, 0, …
3 replies
I have a data retrieval problem that I need some help with. I have a SQL database that has a Reque…
3 replies
hi, here is a thing that bothers me: I created a stored procedure that takes 2 strings as input. On…
3 replies
I want to create a clustered Index on a view referencing Customer table. My view is like this. CREA…
12 replies
Hi guys does anyone know if my file is corrupt? I dont have the database anymore, I saved query re…
4 replies
I have the following queries that process the same data. The select buzzes hrough 160K rows in less…
3 replies
hello i have a bit column in my table, i need to make sure it has the default set to 0 in case null…
6 replies
MS SQL Server 2000 - I ran this to list all tables and their row counts for a Database. select d…
8 replies
I get the error: Msg 4414, Level 16, State 1, Line 15 Could not allocate ancillary table for view o…
5 replies
String or binary data would be truncated. The statement has been terminated. Is t…
3 replies
Hello everyone. I have been tasked with getting some summary data out of a system with a lot more r…
2 replies
This will eventually be done in SSRS, but I need the sql script first. I have a server with multip…
4 replies
Hi Guys, I've got this issue and need you guys help. i want to be able to pass in the database name…
22 replies
How can I identify triggers enabled? It is a field of sysobjects that indicates whether the trigger…
2 replies
Hi all, I have an Issue can any one help me pls. I want the data of a table before the beginning of…
7 replies
Viewing 15 topics - 1,696 through 1,710 (of 17,082 total)
You must be logged in to create new topics.