Topics
Started by
Posts
Last post
I have created a synonym as follows CREATE SYNONYM [dbo].[ms4] FOR [local].[Northwind].[dbo].[Prod…
2 replies
For SQL Server 2008: What is the procedure to delete some data from Lock Table? We can't use NOLOCK…
6 replies
Hi Friends, Which is the best monitoring tool for monitoring the Sql Server 2008 R2 If possible c…
5 replies
I have an example where the table im indexing appears in the join and where clause: select OL1.a, …
4 replies
Hi All - I have a question regarding SQL licensing when using Merge Replication. I understand fro…
2 replies
Hi Team, Am having a stored procedure, it involved conditions, joins. based on conditions and joins…
1 replies
Hi, Can anyone provide a method to loop through a DB's in an instance WITHOUT using the proc sp_MSf…
7 replies
Hi, Can anyone let me know the syntax for "drop if exists" and "select * into from" using Linked Se…
1 replies
We are planning on consolidating alot of our 2005 servers to a sql server blade server using sql se…
6 replies
In my test enviroment i found that out of 269 tables 99 tables does not have primary keys and 4 tab…
5 replies
Hi all, My data contains something like this: userid, web_survey_date, rating, comment. We send sur…
3 replies
I'd have sworn we had an SSIS section round these parts. Anyway. Version: 2k8R2 SSIS via VS2k8 int…
1 replies
Hi All, I want to calculate a summary column on the basis of the column value returning from sub qu…
4 replies
Ihave created thr stg_backup account for back jobs with backup operator preveliges associated with …
3 replies
I have xml something like below in my sql server table <z> <a> <b>1</b> <…
3 replies
Viewing 15 topics - 13,096 through 13,110 (of 30,221 total)
You must be logged in to create new topics.