Viewing 15 posts - 3,301 through 3,315 (of 5,394 total)
You could check index access statistics for the tables in the database:
DECLARE @accessStats TABLE (
db_name sysname,
last_access datetime
)
INSERT @accessStats
EXEC sp_msForEachDb '
SELECT ''?'', MAX(last_access) AS last_access
FROM (
SELECT DB_NAME() AS db_name,
MAX(last_user_seek) ...
March 31, 2011 at 1:41 am
Don't create database users for windows logins, that should be enough.
March 31, 2011 at 1:28 am
annasql (3/30/2011)
But we do want to keep the old login for other server's access. How can we make this work? to enable the login?
After changing the service account, create a...
March 31, 2011 at 1:27 am
I'm afraid it's not possible with express edition.
You can do something similar with compact edition, but it's a totally different thing from a "regular" SQL Server.
March 31, 2011 at 1:23 am
I googled "Sql Server orphaned users" and got a lot of useful links.
Have you tried that?
March 31, 2011 at 1:19 am
Don't cross post please.
Replies here: http://www.sqlservercentral.com/Forums/FindPost1086648.aspx
March 31, 2011 at 1:18 am
It depends.
Can you explain a bit more?
March 30, 2011 at 10:42 am
Please set your font to a smaller size.
Does the user that executes the package have rights on that path?
Did you check if the user is the one you expect?
How is...
March 30, 2011 at 10:40 am
krishusavalia (3/30/2011)
Service pack cause damage.
I would be surprised if it was so. However, you can see how it works in a test environment.
March 30, 2011 at 10:37 am
GilaMonster (3/30/2011)
Restore the 10:30 transaction log backup WITH NORECOVERY
Restore the 11:30 log backup WITH STOPAT 10:59
If the database is still...
March 30, 2011 at 8:50 am
I would restore the database with a new name and stop immediately before the time of the deletion. Then, I would copy the rows deleted by accident to the original...
March 30, 2011 at 6:09 am
BTW, if you still want to set up an encrypted connection with SQL Server, you will have to enable SSL.
This page on MSDN could be a good place to start...
March 30, 2011 at 6:00 am
DBANewbie (3/30/2011)
Am i right to assume that data transferred between the remote server and my machine running SSMS within our network would be unencrypted by default?
I suppose that you...
March 30, 2011 at 5:57 am
Paul White's blog is probably the best online resource for SQL Server internals.
Good day to you too.
March 29, 2011 at 4:14 am
Hi Richard, some days ago I read this interesting blog post on this exact subject.
http://sqlblog.com/blogs/paul_white/archive/2011/02/27/bug-slow-sums-and-averages.aspx
Hope you find it useful.
Gianluca
March 29, 2011 at 1:37 am
Viewing 15 posts - 3,301 through 3,315 (of 5,394 total)