Viewing 15 posts - 3,301 through 3,315 (of 5,393 total)
Don't create database users for windows logins, that should be enough.
-- Gianluca Sartori
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...
-- Gianluca Sartori
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.
-- Gianluca Sartori
March 31, 2011 at 1:23 am
I googled "Sql Server orphaned users" and got a lot of useful links.
Have you tried that?
-- Gianluca Sartori
March 31, 2011 at 1:19 am
Don't cross post please.
Replies here: http://www.sqlservercentral.com/Forums/FindPost1086648.aspx
-- Gianluca Sartori
March 31, 2011 at 1:18 am
It depends.
Can you explain a bit more?
-- Gianluca Sartori
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...
-- Gianluca Sartori
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.
-- Gianluca Sartori
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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
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.
-- Gianluca Sartori
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
-- Gianluca Sartori
March 29, 2011 at 1:37 am
Jeff Moden (3/28/2011)
Gianluca Sartori (3/28/2011)
GilaMonster (3/28/2011)
Not trying to start any bashing or pile-ons, but this has to rate high on the list of most useless replies: http://www.sqlservercentral.com/Forums/FindPost1084783.aspx
Sounds like "OK, just...
-- Gianluca Sartori
March 28, 2011 at 7:35 am
Viewing 15 posts - 3,301 through 3,315 (of 5,393 total)