Viewing 15 posts - 2,071 through 2,085 (of 9,244 total)
drop definitely doesn't and I'm 99.9% certain that rename doesn't either
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 29, 2015 at 6:30 am
if you drop or rename a table the granted permissions will be lost
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 29, 2015 at 5:49 am
Grant Fritchey (5/29/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 28, 2015 at 10:01 am
just use the following for any tempdb files and restart the instance
alter database tempdb modify file
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 28, 2015 at 4:40 am
Great article, 5 stars
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 28, 2015 at 2:42 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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 27, 2015 at 8:15 am
have you ever run DBCC CHECKDB against these databases
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 27, 2015 at 8:10 am
can you provide the full report?
Was this database previously a sql server 2000 database at any time?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 27, 2015 at 6:54 am
Viewing 15 posts - 2,071 through 2,085 (of 9,244 total)