Transact-SQL is the Microsoft extension of ANSI standard SQL.
4
votes
1answer
126 views
What is the best way to replicate a large number of SQL 2008 DBs to a failover instance in Amazon Web Services
Our application creates a new sql database for every customer and we will be continually adding new customers and creating new databases every day.
These databases can range in size from 3 megabytes ...
1
vote
1answer
66 views
variables used in inner queries
im trying to build a query that has something like this
select
id,
(select top 1 create_date from table2
where table1id = t1.id
and status = 'success') ...
0
votes
1answer
105 views
Creating a SQL Server 2005 User Login to Backup and Restore on a Single Database
I have a SQL Server 2005 database server with multiple databases on the server. I need to create a user login 'test1'with the following restrictions:
Login 'test1' should be owner of database 'ABC' ...
0
votes
1answer
278 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 ...
0
votes
1answer
546 views
SQLS Timeouts - High Reads in Profiler
I've audited a SQLS2008 server with Profiler for one day.. the overhead didn't seem to trouble this new client my company has. They are using a legacy VB6 application as a front-end. They're ...
0
votes
1answer
42 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 ...
1
vote
0answers
57 views
Unable to change schema of a Publication Database using TSQL (Ready-roll): being forced stop replication
I am trying to apply schema changes using T-SQL (using Ready-Roll database source control tool with Octopus Deployment) to a Publication database however it is forcing me stop Replication for the ...
