Topics
Started by
Posts
Last post
There is a job running that does an INSERT of all rows from a view into a table. The transaction lo…
5 replies
I have a Powershell script that uses SMO to get data compression status on all tables and on all db…
1 replies
Good Afternoon, The data im using is from an ERP, this means i have to adapt to the data and the da…
3 replies
using sql server 2005 given the following: declare @contact_type table(contactTypeID int,contactTyp…
1 replies
I have a triger (T1) on Server A (SS 2000), that calls a local procedure (P1) which then calls a re…
1 replies
Some body change sql procedure and it effects all production and we want to find who make this chan…
1 replies
I'm wondering if anyone knows whether updates for R2 are available in any other format than online?…
2 replies
I'm looking for a list of DBs across multiple servers and it seems that there should be a fairly ea…
5 replies
When you start up SQL Server, if you were to run: SELECT * from tempdb.sys.tables there are a handf…
9 replies
I have a linked server that seems to be setup correctly. I can successfully execute a very basic d…
6 replies
Hi, I have a string : "UPDATE Persons SET Address='xxx', City='yyy' WHERE xxxID='Test' AND ColumnNa…
2 replies
Hello If I run a query (any query) in the SQL Server Manager and turn on the option 'include aktual…
3 replies
If I were to restore a DB from production to any other server, would the execution plans and statis…
2 replies
Greetings everyone. So after having a few issues here and there with a nightly ETL process, I have…
4 replies
Hi, Is there an automated way to SET ANSI NULLS OFF for a specific object type ?. For example, if i…
3 replies
Viewing 15 topics - 24,406 through 24,420 (of 30,225 total)
You must be logged in to create new topics.