Topics
Started by
Posts
Last post
Hi I have a query that when I add in a first_value windows function goes from returning in a few se…
4 replies
Select top 100 * FROM ReportServer.dbo.Catalog I like to know whether it is possible to write a SQL…
6 replies
Hi all, Is it possible to prevent a database from being restored over by the restore command? Obvio…
3 replies
Will it possible to download for PSSDIAG Configuration manager tool from Microsoft site? Pl. provid…
1 replies
The following SQL works fine. Gets a list of views, sps and functions in the DB. However I would li…
1 replies
Please see attached. This works fine and gets the Definitions of views saved in a txt file. One lit…
4 replies
Hi all, I have created maintenance plans and scheduled them to backup the transaction log every hou…
20 replies
How is it possible to drop statistics on a view when querying sys stats returns nothing? This is wi…
2 replies
My server ERRORLOG files record every "Logon" to our databases. The logs show large numbers of mes…
3 replies
Hi Guys, I'm stuck on a little problem... I have a script for restoring a database from a backup fi…
4 replies
I have a SQL2008R2 server where we log ship a hosted application to. So we can get to the data. T…
2 replies
Apologies for the stupid question -- where do I go to see if a SQL Server instance has an <i>…
2 replies
Hi, I have the following code: USE tempdb GO GO /****** Object: Table [dbo].[nhsOrgs] Script Da…
2 replies
How to call function in a select statement of the stored procedure. I have a function where it take…
5 replies
What are the above called? I want to look up what creates them, how to manage / use but I don't kn…
2 replies
Viewing 15 topics - 2,431 through 2,445 (of 8,629 total)
You must be logged in to create new topics.