Topics
Started by
Posts
Last post
Hello everyone, What is the proper syntax to update one table from another? Thank you..:) Peter M. …
2 replies
Hi All, I need clarification with regard to Data and Log files. The dates for these MDFs and LDFs i…
1 replies
I created a function that takes a date as a parameter. I function executes fine when I call it wit…
4 replies
We use pessimistic locking which is so embedded into the system that it is impossible to change now…
5 replies
I have a stored procedure on a large SQL Server 7 database that extracts data to a remote SQL7 data…
3 replies
Hello everyone, I have an update trigger on one of my tables setup like this: create trigger tu_log…
9 replies
Hi there, Just going thru some procs and came across this one: CREATE PROCEDURE [SP_GetOneComplete…
2 replies
We need to back up our databses in order to create a larger F drive on out SQL server. Does anyone…
2 replies
Hi, All I have a Q for U. I have a table looks like this: ********************************* ZIPC08 …
1 replies
I have the following stored procedure: CREATE procedure user_add @password varchar(50), @dep_id int…
6 replies
Try this, I had to write a split function so here is the code -------------------------------------…
5 replies
Hi, We're seeing deadlocks caused by "lock resources", according to the error capture info. I would…
3 replies
Is there a good way to disable triggers on a table for a specific SP? When I run sp_xyz which upda…
6 replies
I am trying to find out the ms-sql product versions for each linked server I have. This is the fol…
2 replies
I am attempting to access the data in a spreadsheet which is located on another machine (in this in…
3 replies
Viewing 15 topics - 14,341 through 14,355 (of 17,082 total)
You must be logged in to create new topics.