Viewing 15 posts - 91 through 105 (of 152 total)
mart 13485 (6/23/2016)
June 25, 2016 at 8:06 am
You are correct. My apologies you need to backup and restore the SMK used on the original DMK. However this is not done by restore the master database.
But after...
June 16, 2016 at 11:01 pm
Carol Adams (5/6/2016)
I got this to work be deleting the login under the MASTER database and re-adding making sure to add his schema
I have a question.
Was this cluster setup and...
June 15, 2016 at 10:17 am
This is why SQL Server moved schemas from user dependent to independent objects in 2005.
Create a schema per client (you could also move this to its own database but the...
June 15, 2016 at 8:44 am
Just a suggestion but give your support team a batch file that runs a SQLCMD command with your SQL?
June 14, 2016 at 6:56 am
Erland,
Yes of course. For some reason I equated.
A few caveats: Always Encrypted may be available in Enterprise Edition only. You mentioned Access - I'm 100% sure that there...
June 14, 2016 at 6:51 am
David92595 (6/8/2016)
Thank your for that clarification. You may have just made my case to upgrade to 2016 🙂David92595
Setting up and using server side encryption with SQL 2008 isn't...
June 14, 2016 at 6:19 am
Clint-525719 (6/13/2016)
June 14, 2016 at 5:15 am
Single left click on the database in question to highlight it then do the right click and select TOP 1000 option.
June 4, 2016 at 10:44 am
Check the SQL agent account and insure the user running that service has the proper permissions to the network location.
May 31, 2016 at 1:43 pm
I agree with Jeff a partitioned view with your "table lite" criterion is the way to go.
May 30, 2016 at 9:25 am
salliven (5/14/2013)
How do you know that?
I'm managing more Microsoft replication.
But Microsoft replication is slow and inflexible. Our replication program is fast and flexible (example: maximum 0,5 sec replication latency,...
May 30, 2016 at 9:21 am
INT value is 2^32 which is 4.294 billion or -2.147 billion to 2.147 billion. So yes it will count up from 0 (once it reaches 0) starting at -2.147billion.
May 30, 2016 at 9:15 am
I would run a trace, for as long as possible on just activity relating to SA, save that info to a file/database and then do some good old fashion data...
May 25, 2016 at 12:49 pm
APA0876 (5/12/2016)
Smendle (5/12/2016)
TheSQLGuru (5/12/2016)
Smendle (5/12/2016)
The OP wasn't confused or asking about WSFC. He was asking about a SQL Server Failover Cluster...
May 12, 2016 at 1:53 pm
Viewing 15 posts - 91 through 105 (of 152 total)