Viewing 15 topics - 268,171 through 268,185 (of 283,910 total)
Topics
Started by
Posts
Last post
Can we create a constraint between tables in 2 separate databases? TIA, aurora01 Aurora
2 replies
We have new cluster server and total 8GB and have /3GB /PAE on boot.ini file, and awe enabled also,…
6 replies
Hi: We are currently in the process of testing our Webserver migration to Win 2000 and came acros…
1 replies
I have to pull off a report of people in the current database by selection criteria for an appeal. …
3 replies
hi, i am writing a trigger CREATE TRIGGER Ztrig ON TZ FOR INSERT AS BEGIN INSERT TY VALUES (…
1 replies
Whenever I try to run the job through Database Maintenance Plan and it does not run at all. And If …
26 replies
Is there a way to DROP all my foreign key constraints and then to RE-CREATE them (as I cannot use t…
7 replies
Hi DBA's, I got an issue when website is supporting multiple collations. BA need to include UTF-8 f…
1 replies
We're buying a new server and EMC wants to make me a "deal we can't refuse". We are getting a 32G C…
3 replies
Hi, Setting Identity columns for a transaction table is correct? Thanks in advance Jag
4 replies
I have created a trigger using SQL Query Analyser. For modification I open SQL Enterprises Manager …
2 replies
I am trying to get the time value in a 'hh:mm:ss am/pm' format from the getdate() function, can any…
11 replies
Hi guys, I think it is a bad idea to set identity option for a column in a table(master table/trans…
1 replies
Dear friends, Let say i have 500 sales records with four salespersons, SP1= 100 sales records SP2= …
6 replies
SELECT x,y,z FROM A LEFT JOIN B AS b1 LEFT JOIN B AS b2 WHERE condition ORDER BY A.h this is a ske…
3 replies
Viewing 15 topics - 268,171 through 268,185 (of 283,910 total)