Viewing 15 posts - 2,716 through 2,730 (of 9,241 total)
charipg (11/21/2014)
we can find free space on disks with 'xp_fixeddrives'.i need script to find all disk size(total size\capacity) in the servers, any help ?
easy via Powershell
Get-Volume | ?{$_.DriveType -EQ...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2014 at 7:06 am
This should be the database engine url not the mirror endpoint as you have specified
READ_ONLY_ROUTING_URL = N'TCP://SQL01.contoso.local:5022'));
So, as an example, if i set my sql server instance called bob on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2014 at 7:01 am
The ReadOnly routing URL setup is a manul process via PowerShell or TSQL, your readonly routing url and your mirror endpoint urls are the same, this is incorrect! Refer back...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2014 at 6:50 am
would have thought the biggest issue here is that conversion is not allowed from type date to type bit!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2014 at 6:44 am
was this database originally a sql server 2000 database?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2014 at 6:00 am
arrjay (11/20/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 20, 2014 at 3:45 am
this thread is old!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2014 at 2:08 pm
robin.pryor (11/19/2014)
So there's just no way to disable a Windows Group login?
only deny, but be careful here. Please see this link
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2014 at 2:07 pm
windows groups cannot be denied as detailed here
The link states;
MSDN - ALTER LOGIN (Transact-SQL)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2014 at 10:48 am
no it's a temporary workspace
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2014 at 10:36 am
ramana3327 (11/17/2014)
I am working with SSRS. I do have admin rights. I can connect to the url https://localhost/Reports and can create the new reports and subscription. Delete the reports and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2014 at 5:32 am
rupert.hirst (11/18/2014)
Ok, I'm with you, yes I was missing the specific -d <dbname> parameter, and with this added, it looks to work.
With the -d parameter my connection is to the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2014 at 8:27 am
SQL Galaxy (11/18/2014)
Thank you for mention missed points(number), I have updated my documents.
No, they are still a very high level, you need to be looking a lot deeper into this....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2014 at 6:49 am
You've missed out very important steps and all of this is required before you even get to creating and configuring a listener. This is still at a very high level,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2014 at 5:30 am
rupert.hirst (11/18/2014)
Hi,Yes, sorry, I didn't make that clear, the database name is in the script:
Select * from <db>.<schema>.<table>
Cheers
Roop
Ok, let me expand a little, i can't see the database name in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2014 at 5:21 am
Viewing 15 posts - 2,716 through 2,730 (of 9,241 total)