Are you saying that you are developing in BIDS on the same machine where SQL Server Agent is running? What account is the SQL Agent service running as? Log into...

I just disabled it in dev and qa and restarted the sql server service and it will be disabled in production before the next scheduled maintenance that requires a service...

and that approach happens to align quite...

gopinathreddy.d (2/20/2013)

---

I Have Table With Column With DataType Varchar(50) Which Is Having A Unique Constraint On That.

For Example : I want To Insert These 3 Values Into Above Column

'ABC' ...

homebrew01 (2/21/2013)

---

opc.three (2/21/2013)

---

You can't restore data for specific tables without...

You can't restore data for specific tables without the help...

Are you sure that had anything to do with anything?

, and adding the user to the dbReader/dbWriter database role on the...

andykr-773587 (2/21/2013)

---

Here is the scenario:

On a single server there are two databases:

DB1 = OLTP database for an application

DB2 = Audit Log Database

Cross database ownership is...

1. Make sure gpg is correctly installed on the server in the location you're referencing.

2. Log into the server as the SQL Agent service account and accept the key...

Your approach would be correct if you were in a disaster recovery scenario and wanted to recover as much data as possible.

As for why you would want previous log backups,...

sam-433147 (2/20/2013)

---

i run a Tsql query that move's a file from one computer to another

set @sql='move '+@file1+' '+@file2

EXEC master..xp_cmdshell @sql , NO_OUTPUT

now, i want the query to wait...

Ed Wagner (2/21/2013)

---

In the original post, it's noted that there is a base table and 10 children. I'd bet there's a missing index on the foreign key of at...

Than you for the test data. There were some errors in it but I got it to work. Here it is for other onlookers:

INSERT INTO dbo.StudentHistory

...

What is the purpose of capturing the results in a table with the column name that differs? I am not seeing a clear and easy way to do this with...

Thank you for the table definitions. This looks like homework, which is fine, I am happy to help, but I need for you to provide the other three things I...