Hello,

According to my understanding, you can only install 1 physical instance of SSIS on each machine. Check the following link for an article which discusses the same.

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/ec460c06-5a6f-4880-aefb-5d1eaa09c42b/

Hello mkarthikeyan,

It would be hard to suggest without having a look at the code. To make a start, check the execution plan of the stored procedure and see which part...

Hi,

Please check the following links:

http://www.sqlservercentral.com/articles/Triggers/64214/

http://www.sqlservercentral.com/Forums/Topic624502-8-1.aspx#bm624579

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=60457

If you create a login and set 'master' as default database then, the user will only be created in the master database. The login/user will not have access to any...

toddasd (12/5/2012)

---

Change to

declare @q varchar(max)

SELECT @q = ISNULL(@q, '') + 'DELETE FROM ' + tablename + ' where tid =' + convert(char,rowid) + '; ' from #incoming where...

ananda.murugesan (12/6/2012)

---

yes..Thanks

user apperaing in secondary instance database by atuomatically during restore log shipping process..But it won't connect the application due to login is not apperaing under security->Login, Does we...

Hello Kapil,

Does the destination database have any existing data? If not, why not use backup-restore?

If the destination database already has some data and you are copying data from existing tables...

Woh ! I thought you only need to execute the last delete statement.. But, I guess you need to execute a delete statement on all the tablenames from your temporary...

Hello Casper,

According to my knowledge of deadlocks,

Deadlocking occurs when two or more user processes have locks on separate objects and each process is trying to acquire a lock on the...

Hello Alan,

Try this...

DECLARE @QRY varchar (255)

SELECT @QRY = 'DELETE FROM ' + tablename + ' where tid =' + convert(char,rowid) from #incoming where action = 0

--PRINT @QRY

EXEC (@QRY)

Hello David,

Please check the below link.. Is this you were looking for?

http://www.mssqltips.com/sqlservertip/1311/web-based-database-administration-for-sql-server/

Hello Bala,

Tail log backups are only needed in case of a Disaster Recovery scenerio (Point in time recovery is needed). One should not take taillog backup in normal routine.

One reason could be that other users are not part of CTAP_professional group and only this group has access to the database.

However, the most probable reason could be that the...

Hello,

Please refer to the below link. The second sentence says "Login auditing can be configured to write to the error log on the following events".

http://msdn.microsoft.com/en-us/library/ms175850(v=sql.105).aspx

Hello,

Do you want to have connectivity between 02 SQL Servers or, SQL Server to any other RDBMS?