Try this...

SET @DomainUser=@Domain + '\Username' -- New Variable & concat operation

exec sp_grant_publication_access @publication = 'Application', @login = @DomainUser

GO

IMO 4th option is good. I can’t guide you how to handle it in .Net application but my colleagues (front end developers) follow the same approach frequently so I assume...

If the objective is to avoid fully qualified names for tables, use Synonyms instead.

Views should be used to enhance security (visibility) of data. I don’t think you are trying to...

Index & constraint creation / enabling should be done after data load. If you are inserting data in batches, you can disable / enable the index just for the batch.

Even...

You can set the time out value but I would prefer to verify the stored procedure execution plans. I would recommend you to trouble shoot on the factors that lead...

Are you sure the queries in Option A have significant differences in execution plans (thus performance)? Also, if it is, can't they be rewritten for better performance?

If the performance difference...

It might help...

active save point

http://social.msdn.microsoft.com/Forums/en/sqlreplication/thread/5a2db7df-c9af-4514-8981-167380799ee7

Per BOL:

There are many ways to back up your Microsoft SQL Server Analysis Services databases and they all require that you have server administrator and database administrator permissions. You can...

The main advantage with cube is they can serve as offline storage. So if you lose the connection to your data server, you would still be able to analyze the...

It’s a good practice to add logging in SSIS package. SSIS package itself can log its activities to a file. Didn’t you implement anything like this in your SSIS package?

First suggestion, don’t start with SQL Server 2005. Please download SQL Server 2008 R2 (or higher) EVAL edition and start practicing SQL. Download Adventure works Database from codeplex it will...

Please don’t hijack the thread. Start a new thread for your problem. We will try to provide a solution.

I had similar requirements for one assignment & luckily my customers bear the pain (to provide the SEED data).

However in our investigation we found something interesting & brought into attention...

Please verify Log shipping status. Is it disabled? Do you find any errors in Logs for Log Shipping?

For this simple scenario CDC is not required. Add two audit columns in Employee table ‘Modified_By’ & ‘Modification_Date’ (optionally add 2 more columns ‘Created_By’ & ‘Creation_Date’). It should satisfy your...