Topics
Started by
Posts
Last post
I am wondering how I can check the status of every transaction within an active X script. Below is…
3 replies
Is it possible to have a Foreign Key in one db1 and its referenced table in db2 in another. i.e. I …
1 replies
Could someone tell me how sql server decides what query plan to use? We looked at a select stateme…
2 replies
Hi, Can anybody tell how to use the profiling stored procedures in SQL 2000. Basically I want to wr…
1 replies
I've read that you should put SET NOCOUNT ON at the start of a stored procedure. What is NOCOUNT, a…
2 replies
Hi, I would like to know..... how the transaction log can be read on sql_server. I realise it's a p…
1 replies
Hello All and Good Day I am looking for a way to store the current TimeofDay in a table, but not in…
1 replies
Gentleman, I have a small dilemma and would interested if it can be done in sql. Here is the deal: …
1 replies
hi i will like to find out if anyone noe how to localized a website eg.like let user choose what la…
1 replies
I want to compare all the tables in 2 databases (production and development) and if there are any d…
3 replies
The following attempt to place a transaction lock on resource XXX always fails with a return value …
1 replies
I have a column in several tables named startdate_d, I want to select the max(startdate_d) from all…
2 replies
I'm trying to create an SP CREATE PROCEDURE [dbo].[usp_DBUpdate] @DBName VARCHAR(5) AS UPDATE @DBNa…
2 replies
Hi, I execute a bcp command from dos prompt, like this: bcp pub..tablename -Uxxx -Pxxx -Sservername…
2 replies
I have a SP, which has a character input variable. I want to use this variable as the IN expression…
2 replies
Viewing 15 topics - 4,156 through 4,170 (of 4,454 total)
You must be logged in to create new topics.