The t-sql tag has no wiki summary.
0
votes
1answer
86 views
sql script not running from task scheduler
I'm trying to run a MS SQL Server backup from the Task Scheduler (Windows Vista, MS SQL Server Express 2005)
If I run the script manually (open the cmd and execute the script) it works.
If I add the ...
2
votes
1answer
47 views
How can I create a database backup replacing the previously created backup file?
If I backup my SQL Server 2008 R2 database with the following command
set @BackupFileName = N'C:\backup\Production-db.BAK' BACKUP DATABASE
[Production-db] TO DISK = @BackupFileName
and run the ...
0
votes
1answer
11 views
MSSQL2005: is there a sproc to set the default distribution agent profile?
I'm trying to work out how to set the default profile for the distribution agent programatically using t-sql. I see there is the sp_help_agent_profile and sp_help_agent_default sprocs which allow you ...
0
votes
3answers
67 views
T-SQL query to schedule the back-up by using Transactional logs!sql server 2008
Hello i am new to sql server and i don't know any thing about backing up database using tsql i am trying to find out the procedure to do following but unsuccessful.
T-SQL query to schedule the ...
0
votes
2answers
124 views
How to keep Ms-SQL database always UP: mirroring or replicationg?
I have several Tb databases in the Windows Server 2008.
I would like to keep alive the service when the server is failing or the raids are needs to be rebuild.
Which model to choose Replication or ...
0
votes
1answer
65 views
Verify SQL Server Mirroring failover is successful
We have database mirroring configured as "high safety without automatic failover" on 23 databases. Both partners contain principal and mirror databases. I created two scripts that would failover ...
0
votes
1answer
40 views
Automatically drop FK's to re-create a table and then automatically put the FK's back
I have a number of incidents where SSMS tells me table recreation is required, even for something simple like making a column nullable. If this table is referenced by FK's, I would ideally like to ...
0
votes
2answers
115 views
query maintenance plan schedule
can I query the schedule of a maintenance plan? I want to automate checking that backups were run.
Thanks
0
votes
2answers
94 views
Cannot drop a table in SQL 2005
I have a SQL Server 2005 SP3 box that one of my developers created a temp table on that we cannot seem to remove because it somehow got brackets in the name of the table?
SELECT Name, object_id FROM ...
0
votes
1answer
79 views
Object definition in MS SQL 2000
I was looking for a way to generate object definition (in my case stored procedure defintion) in SQL 2000 like I can get in SQL 2005 : select definition from sys.all_sql_modules.
