Topics
Started by
Posts
Last post
I'm seeing something a bit weird I have a stored procedure that inserts some data into a table, onc…
3 replies
HI ALL, I CREATED A TABLE AND APPLIED CHECK CONSTRAINT USING IN AND LATER I AM ENTERING DATA WHY CH…
8 replies
hi all, When does a SPID status change to 'Sleeping' and what does that indicate? I'm assuming that…
7 replies
I'm trying to optimize some stored procedures and using the DTA (database tuning advisor) it is sug…
3 replies
I am getting the following error from my application logs.the db is SQL2005 Ent edition and os is w…
1 replies
I have a query that is selecting 25 random rows, now, once those rows are selected I want to update…
4 replies
hey hi anybody knows how do i insert the current DateTime into a SP? it seemed SYSDATETIME is not r…
2 replies
Hi Guys, I have an job that is running on one of our servers and I need to find out who created i…
3 replies
Just a quick question re transaction log backup file locations: If I backup directly to a shar…
1 replies
Hi friends can any one tell me how to check whether the server is 32 bit or 64 bit? I have Standard…
10 replies
I have linked server to vfp9 using latest driver as per sp_addlinkedserver @server = 'FRED', @sr…
5 replies
Where do the default return values come from? eg. If I have a stored procedure that doesnt have a r…
3 replies
I'm quite new to deadlocks. Can lock mode U and X co-exists on same object by different process? In…
6 replies
I have a work table that has 1 to N records where N could be very high (several hundred million). I…
2 replies
I have a table with static data. For reasons way too long to go into, I need to add a column, and t…
5 replies
Viewing 15 topics - 4,621 through 4,635 (of 10,974 total)
You must be logged in to create new topics.