It is where you say you map an SSIS package to the folder. Just map it not as X:\MyShare but as \\Server2\MyShare

Hi,

The solution is:

1. Create local Windows accounts with the same user name /password on both servers if they are not in the same or trusting domains.

2. In your SQL...

That is exacty what I am doing.

I store server names in a table in a database and then dynamic SQL Script that uses OPENROWSET is generated to use the...

I prefer SSRS (Reporting Services) with its Export button where you can export to Excel, PDF and other formats.

Hi All,

I know lot of people with the position DBA who are actually business superusers who manage the application, user access, data as managed by application functionality and they...

The only reason you are a member on this site because you want to better perform your job. And this does include the research and it does exclude relying on...

Lynn,

what I mean is that a lot of people on this site are not SQL Server professionals. Some members -yes, and of a very high standards. But a lot of...

Steve Jones - Editor (8/25/2008)

---

If you use Google to answer a question geared for your knowledge, such as an exam question, the Question of the Day, etc., then you're cheating....

GO should never be used as identifier.

http://msdn.microsoft.com/en-us/library/ms189822.aspx

Reserved Keywords (Transact-SQL)

This is not T-SQL keyword now but is on the list on ODBC keywords (second list in the referenced article)...

Steve,

This is a know fact that changing the activity and even being asleep let your other brain grey cell work. I had to write a course paper on that many...

On the Security tab of Linked Server properties you have to add your DOMAIN\sqlman login as Local Login and check Impersonate checkbox or add a remote server's valid login name...

Somebody must have run sp_configure or something. Did you try to reconfigure per the error message suggestions?

To run as a job:

Start your Agent on a domain account. Add this account to both SQL Servers with the appropriate rights to the databases before you start Agent on...

Hi,

Good Question!!!! For once answered correctly.

I would love to see i and other mathematical imaginary features and operations in SQL Server just a little bit more complex than listed...

Try this to create and populate the table with numbers:

CREATE TABLE [#tblNumbers]( [number] [int])

Go

insert #tblnumbers(number) values( 1)

Go 100

Declare @i int

Set @i = 0

Update #tblnumbers

set @i = number =...