Viewing 8 posts - 46 through 53 (of 53 total)
Using Activity Monitor can look at details for each session to see what SQL they are executing. Also paying attention to HostName can give you an idea where the...
June 13, 2012 at 8:49 am
June 13, 2012 at 6:16 am
In SQL 2008 and above a database can be encrypted. You can query the is_encrypted column in sys.databases to determine whether TDE is enabled for a particular database.
for more...
June 13, 2012 at 5:50 am
I assume you have corrected this by now, but figured I'd put my 2 cents in. I set up our reporting environment last year and remember getting this type...
June 12, 2012 at 12:53 pm
If they are on the same physical server you can use task manager (processes tab) to see the memory that is allocated to each sqlservr.exe. May need to click...
April 6, 2012 at 8:43 am
Actually looks like i now have this working for SSMS 2005 (not SSMS 2008 R2), which may be good enough for now. Below is what I think got it...
January 10, 2012 at 10:09 am
Phil Warren (10/21/2011)
The DTS packages are the biggest reason, we haven't migrated off of SQL 2000 sooner.
Dont let DTS stop you from migrating/updating to 2005. DTS works fine in...
October 21, 2011 at 8:24 am
2005 & 2008r2. Mostly 2005 with new projects going on 2008r2.
October 21, 2011 at 5:24 am
Viewing 8 posts - 46 through 53 (of 53 total)