This should give you the SP and build number:

SELECT @@Version;

From the build number you can lookup...

If the role is being lost when you run your update scripts you need to look and see what you...

Here is another link to Technet that contains this information: http://technet.microsoft.com/en-us/magazine/gg552991.aspx

Again, something written by Paul Randal.

Did you read the information that he linked to about the version store? From: http://blogs.msdn.com/b/sqlserverstorageengine/archive/2009/01/01/managing-tempdb-in-sql-server-tempdb-basics-version-store-growth-and-removing-stale-row-versions.aspx

...

sepich.eric (4/6/2011)

---

I have insert statement I will attach below. Sometimes funny characters come in and cause my insert to fail. I want to know what those characters are so I...

Wow, we have never run into that, and we use ALTER a lot on procedures...

What are you trying to escape the characters in? A LIKE expression in the WHERE clause? If so check the BOL documentation: http://msdn.microsoft.com/en-us/library/ms179859.aspx

Though I haven't seen the need to escape...

My guess is that you are getting a different execution plan for a large query that is using tempdb for large sorts and/or large joins that wasn't happening on the...

Another option if you just need a WHERE clause on the Oracle side is to use OPENQUERY:

SELECT

Local_Table.Col1,

Remote_Table.Col2

FROM dbo.Local_Table Local_Table

INNER JOIN OPENQUERY(LinkedSever, 'SELECT * FROM...

You can try using the REMOTE join hint that tells SQL Server to try to run the process on the right side of the join. Here is an example:

SELECT

...

How are you modifying the SPROC?

If you do like a lot of people and DROP the procedure and then CREATE it again, yes the permissions are lost. You can use...

Thanks for the question, that is interesting to know. I have always heard everything in SQL Server is logged, but I was thinking that the version store didn't need to...

Better is sort of figurative. In my opinion the solutions go in this order from best down:

* New install on new server, migrate data test, then do a final data...

MyDoggieJessie (4/6/2011)

---

The reporting guys at my company created VIEWs in the past that comprised of 2-5 tables that often have 20+ million rows of data in each of the tables...

Karlier,

Are you waiting until the DMV, sys.dm_database_encryption_keys, shows that the decryption has completed before restarting the instance? (Both encryption and decryption are done as a background process.)