Topics
Started by
Posts
Last post
I'm running a BCP IN to a table that has a unique index with ignore duplicate key. I'm getting the …
2 replies
We need to log the before and after values of fields that have been updated in a table. Also need t…
4 replies
I have defined a variable "@varMonth char(2)", and then initialized it with the line: SET @varMonth…
2 replies
I created the following sp as dbo then run it as cmss_user. The table gets created but then the sel…
1 replies
I recently installed SQL 2000 on my Desktop. I kept the existing SQL 7 installation. I run a stored…
5 replies
Does anyone know of a way of producing a Stored Procedure stacktrace from within a stored procedure…
1 replies
I am trying to export a table to a file. I use bcp command to do this. I need the column names as …
2 replies
Hi, I'm using the SQL Server 200 and I have a little problem, I need to create some procedure for g…
4 replies
I need ideas on why I have a very high (70%) RAM usage for my SQL server 2000. Have 3/4 of a Gig of…
7 replies
Hi, Is there anyway in SQL statement to retrieve only the date value from a datetime datatype colum…
3 replies
Can anyone tell me if there is a way of getting back a full list of all the triggers in a database,…
1 replies
Hi Is there anyway you can get the information about a file you have received i.e. the creation dat…
4 replies
i am trying to select records randomly from a table. like 10% of all records or so, what can i use …
1 replies
We are not able to debug the stored procedures in the debug screen of the query analyzer. The syste…
1 replies
This is perhaps a very, very simple question, but does anybody out there know of any limit to the n…
7 replies
Viewing 15 topics - 7,141 through 7,155 (of 7,464 total)
You must be logged in to create new topics.