@SQLSACT please answer WolfgangE re: whether the table accepts updates. Also, does the table accept deletes? You could be seeing a spreading out of the index on disk due to...

No, not using SNAC 11.

http://www.sqlservercentral.com/Forums/Topic1317581-2799-1.aspx

You could try using SNAC 10 but may run into problems with DTC. See workarounds:

http://connect.microsoft.com/SQLServer/feedback/details/731869/using-sqlncli10-to-create-a-linked-server-to-sql-server-2000-causes-a-fault#

Did you make it beyond the phone interview?

Since you are learning and are on SQL 2008 I would recommend acquainting yourself with the MERGE statement. INSERT...SELECT is fine, but MERGE is much more versatile and intuitive (in...

MartJ (12/19/2012)

---

Hi all

I have a similar issue so I though a more in depth description may help vineetbhargav too.

I have a proc that is used in a report. The report...

The restore command has to be executed...

I just tried it but the autogrow events themselves do not collect anything for us to see in the TextData column. The most targetted way to figure this out would...

At times, depending on the isolation level or table hints (which the reporting engine sometimes provides), multiple locks will be opened for a single query. Post-processing to roll these multiple...

The server executing the SSIS Package must have all dependent software installed to support the running of the package. So, even if a package resides on a different server from...

You cannot retrieve the password in clear text from SQL Server once it has been set in case that is what you are asking.

To get a 'create login' statement...

I hope people aren't having to use DBCC CHECKCONSTRAINTS all that often 😉

DBCC CHECKIDENT is one that comes to mind that I have...

bugg (12/14/2012)

---

opc.three (12/13/2012)

---

Connection from their IP? I thought you said you were connecting to a remote MySQL server. From a network security perspective only an outgoing connection from the server...

peter-661823 (12/14/2012)

---

Thanks again for answer

I understand your way to set autogrow "grow by Megabytes", I think I will do this in future too. But this does not solve the reason...

Connection from their IP? I thought you said you were connecting to a remote MySQL server. From a network security perspective only an outgoing connection from the server running your...

Store the filename in a variable and append the value in a new column to your pipeline using the Derived Column Transformation.