Viewing 15 posts - 3,856 through 3,870 (of 9,244 total)
ALTER TABLE [INVOICE]
DROP CONSTRAINT [INVOICE_PK] WITH (MOVE TO SECONDERYDATA)
After the move, we now recreate the PK Constraint:
ALTER TABLE [INVOICE]
ADD CONSTRAINT [INVOICE_PK] PRIMARY KEY CLUSTERED
( [column name] ASC
)WITH (IGNORE_DUP_KEY...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2013 at 4:25 am
Drop the cursors and the calls to xp_fixeddrives and fsutil and use the following
[Code]wmic volume get capacity, "free space", name[/code]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 6, 2013 at 1:19 am
Junglee_George (12/5/2013)
HiPlease explain the Difference between Now() and Today() functions in SSRS reports. Are they both same or different..??
Note that these are not T-SQL date\time events they are visual studio...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2013 at 8:44 am
inevercheckthis2002 (12/5/2013)
After doing so,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2013 at 8:38 am
Aatish Patel (12/5/2013)
-----See if there are any orphan users:
EXEC sp_change_users_login 'Report'
The output was :
finq_sql...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2013 at 8:31 am
Gerard Silveira (11/7/2013)
When you say easier to store with the VM, do you mean the same LUN that the .vmdk file is stored on
OR
Do...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2013 at 3:50 am
Leo.Miller (2/14/2011)
David Benoit (2/14/2011)
They had a nice shiny new SAN installed to improve performance,
Storage Area Networks are implemented for consolidation not performance, much like virtualisation is implemented for consolidation....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2013 at 3:45 am
cpathidba (12/5/2013)
Hi Praveen,I had given those permissions also,still it was showing same error, please help us.
thanks & regards
Chalapathi
It is the SQL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2013 at 3:37 am
So these are native backups from 2005 rtm?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 29, 2013 at 10:21 am
which version\edition of sql server are you using?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 29, 2013 at 8:22 am
Welsh Corgi (11/27/2013)
I atttached the word work with screen shot and tried to open myself but I could not open it?How can I embed an image intop my post?
Thanks.
I opened...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 29, 2013 at 7:08 am
AShehzad (11/25/2013)
If you can ping the server from your machine then probably it will not be a firewall issue.
Correct, ICMP traffic is the first traffic a firewall usually blocks. If...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 29, 2013 at 7:00 am
MohamedDBA (11/24/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 29, 2013 at 6:56 am
NJDave (11/27/2013)
Could someone provide insight on using 2 VMs in a cluster fro SQL Server 2008 R2 (or higher)?
Today, I have 2 physical boxes in an active passive cluster that...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 29, 2013 at 6:32 am
pradeep.mohan (11/26/2013)
Will it affect domain changes in log shipping and mirroring???
Because currently SQL server services running on xxxx\xxxxx domain account and log shipping and mirroring working properly. We are planning...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 29, 2013 at 6:16 am
Viewing 15 posts - 3,856 through 3,870 (of 9,244 total)