Quick to disable and enable all SQL jobs on your server
USE MSDB
-- DISABLE ALL SQL JOBS
UPDATE dbo.sysjobs
SET Enabled = 0
WHERE Enabled = 1
-- ENABLE ALL SQL JOBS
UPDATE dbo.sysjobs
SET Enabled = 1
WHERE Enabled = 0
Leave a Comment Quick to disable and enable all SQL jobs on your server
USE MSDB
-- DISABLE ALL SQL JOBS
UPDATE dbo.sysjobs
SET Enabled = 0
WHERE Enabled = 1
-- ENABLE ALL SQL JOBS
UPDATE dbo.sysjobs
SET Enabled = 1
WHERE Enabled = 0
Leave a Comment RESTORE DATABASE [MyDatabase] FROM DISK = N'E:\MyDatabase.bak' WITH FILE = 1, MOVE N'MyDatabase' TO N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\MyDatabase.mdf', MOVE N'MyDatabase_Log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data\MyDatabase.ldf', NOUNLOAD, REPLACE, STATS = 10 GO
http://www.codeproject.com/Articles/708720/Solution-The-WITH-MOVE-clause-can-be-used-to-reloc
Leave a Comment
SELECT c.name AS ColName, t.name AS TableName FROM sys.columns c JOIN sys.tables t ON c.object_id = t.object_id WHERE c.name LIKE '%LookingForThisColumn%'
Leave a Comment
DECLARE @Search varchar(255) SET @Search='CITERIA' SELECT DISTINCT o.name AS Object_Name,o.type_desc FROM sys.sql_modules m INNER JOIN sys.objects o ON m.object_id=o.object_id WHERE m.definition Like '%'+@Search+'%' ORDER BY 2,1
Leave a Comment
Changing it one by one use the following.
ALTER SCHEMA dbo TRANSFER someschema.someobject;
Changing all stored procedures.
select 'ALTER SCHEMA dbo TRANSFER ' + SPECIFIC_SCHEMA + '.' + ROUTINE_NAME from INFORMATION_SCHEMA.ROUTINES where ROUTINE_TYPE='procedure'
Leave a Comment
private void InsertAndUpdate() { NorthwindDataContext db = new NorthwindDataContext(); //Insert a record Customer newCus = new Customer(); newCus.CustomerID = "YYYZZ"; newCus.CompanyName = "Company_Z"; db.Customers.InsertOnSubmit(newCus); db.SubmitChanges(); //Update a record Customer record = (from p in db.Customers where p.CustomerID == "12345" select p).SingleOrDefault(); Console.WriteLine(default(Customer)); if (record != default(Customer)) { record.CompanyName = "Company_A"; } db.SubmitChanges(); }
Leave a Comment