Viewing 15 posts - 2,071 through 2,085 (of 9,253 total)
OK, just tested and it seems it does retain the permission when renaming, sorry for the mistake
May 29, 2015 at 6:42 am
drop definitely doesn't and I'm 99.9% certain that rename doesn't either
May 29, 2015 at 6:30 am
if you drop or rename a table the granted permissions will be lost
May 29, 2015 at 5:49 am
Grant Fritchey (5/29/2015)
May 29, 2015 at 4:01 am
mataleao87 (5/28/2015)
mataleao87 (5/28/2015)
Using google produces a pretty good list of people who have experienced this before. They all pretty much say the same thing to fix it. &ie=utf-8&oe=utf-8]https://www.google.com/search?q=The+Remote+Procedure+Call+failed+[0x800706be]&ie=utf-8&oe=utf-8
I tried to...
May 29, 2015 at 4:00 am
the metadata is stored in the master database. The main catalog is sys.master_files which contains file information for all databases. There is also a catalog inside each database called sys.database_files...
May 29, 2015 at 3:56 am
the network teams have nothing to do with it.
Also, each mirror endpoint on each instance is relevant to that instance only, the configurations are held in the AlwaysOn group config.
You're...
May 28, 2015 at 10:01 am
just use the following for any tempdb files and restart the instance
alter database tempdb modify file
May 28, 2015 at 9:55 am
SQL-DBA-01 (5/27/2015)
Thnx Perry.So is my automated script wrong (attached one in previous mail) per the process of enabling aTDE??
Do I need to do any changes to it? Plz suggest.
I don't...
May 28, 2015 at 4:40 am
SQL-DBA-01 (5/26/2015)
I wrote an automated script to implement TDE, but I found that after any db is encrypted, the "is_master_key_encrypted" column shows 0.
Can you suggest reviewing my script what...
May 27, 2015 at 10:20 am
it is not possible or even supported to rename a named instance. The only name you can change is the computername. For instance, a named instance BLOGGS on computer FRED...
May 27, 2015 at 9:41 am
you may install 2 clustered instances using Standard edition onto a 2 node cluster like so
Server 1
SQL_Instance_1
SQL_Instance_2
Server 2
SQL_Instance_1(Failover)
SQL_Instance_2(Failover)
May 27, 2015 at 9:38 am
you cannot rename a named instance.
Here are the supported upgrade paths for sql server versions
https://msdn.microsoft.com/en-us/library/ms143393(v=sql.110).aspx
May 27, 2015 at 8:15 am
have you ever run DBCC CHECKDB against these databases
May 27, 2015 at 8:10 am
Viewing 15 posts - 2,071 through 2,085 (of 9,253 total)