Viewing 15 posts - 5,146 through 5,160 (of 9,399 total)
You'll want to use MODIFY FILE in your ALTER DATABASE command. See https://msdn.microsoft.com/en-us/library/bb522469%28v=sql.110%29.aspx
September 16, 2015 at 6:20 am
I don't know of any documentation on how you build your folder structure, but purely for organization and permission reasons, I would put them in folders.
September 16, 2015 at 6:15 am
elmnas (9/16/2015)
I didn't know that...
I wonder is it hard to copy an existing SQL db to a new virtual machine if I install SQL server
I believe the hard part...
September 16, 2015 at 6:11 am
jasona.work (9/16/2015)
/swoon
Brought my...
September 16, 2015 at 6:08 am
I've never used it, so they all looked a bit tricky to me.
September 16, 2015 at 5:32 am
BL0B_EATER (9/16/2015)
Eirikur Eiriksson (9/15/2015)
Ed Wagner (9/15/2015)
whereisSQL? (9/15/2015)
Ed Wagner (9/15/2015)
djj (9/15/2015)
Ed Wagner (9/15/2015)
BL0B_EATER (9/15/2015)
BWFC (9/15/2015)
whereisSQL? (9/15/2015)
Ray K (9/15/2015)
Ed Wagner (9/15/2015)
Eirikur Eiriksson (9/15/2015)
djj (9/15/2015)
Ed Wagner (9/15/2015)
anthony.green (9/15/2015)
Ed Wagner (9/14/2015)
InspireEureka
Vacuum
tube
Commute
Traffic
Jam
Jelly
Roll
UP
Town
Saturday
Training
Wheels
Muscle Car
Rumble
Jungle
Guns and Roses
September 16, 2015 at 5:30 am
Kristen-173977 (9/15/2015)
chrisph (9/15/2015)
the only backups are of the mdf and ldf files
I hope they were "transactionally consistent" (if that is the right word?!) when they were backed up.
Suggest running DBCC...
September 15, 2015 at 8:40 pm
Database jobs are run by the SQL Agent. Take a look at the network account the SQL Agent service runs as and make sure it has permission to do...
September 15, 2015 at 8:32 pm
SQLRNNR (9/15/2015)
Ed Wagner (9/15/2015)
Sean Lange (9/15/2015)
SQLRNNR (9/15/2015)
Brandie Tarvin (9/15/2015)
Alvin Ramard (9/15/2015)
Question: Difference between 32 bit and...
September 15, 2015 at 7:48 pm
Sean Lange (9/15/2015)
SQLRNNR (9/15/2015)
Brandie Tarvin (9/15/2015)
Alvin Ramard (9/15/2015)
Question: Difference between 32 bit and 64 bit?
Answer: 32...
September 15, 2015 at 6:35 pm
whereisSQL? (9/15/2015)
Ed Wagner (9/15/2015)
djj (9/15/2015)
Ed Wagner (9/15/2015)
BL0B_EATER (9/15/2015)
BWFC (9/15/2015)
whereisSQL? (9/15/2015)
Ray K (9/15/2015)
Ed Wagner (9/15/2015)
Eirikur Eiriksson (9/15/2015)
djj (9/15/2015)
Ed Wagner (9/15/2015)
anthony.green (9/15/2015)
Ed Wagner (9/14/2015)
InspireEureka
Vacuum
tube
Commute
Traffic
Jam
Jelly
Roll
UP
Town
Saturday
Training
Wheels
Muscle Car
September 15, 2015 at 6:31 pm
djj (9/15/2015)
Ed Wagner (9/15/2015)
BL0B_EATER (9/15/2015)
BWFC (9/15/2015)
whereisSQL? (9/15/2015)
Ray K (9/15/2015)
Ed Wagner (9/15/2015)
Eirikur Eiriksson (9/15/2015)
djj (9/15/2015)
Ed Wagner (9/15/2015)
anthony.green (9/15/2015)
Ed Wagner (9/14/2015)
InspireEureka
Vacuum
tube
Commute
Traffic
Jam
Jelly
Roll
UP
Town
Saturday
Training
September 15, 2015 at 12:10 pm
Alvin Ramard (9/15/2015)
One question on Ask SQL Server Central is just begging for a smart *** answer!Question: Difference between 32 bit and 64 bit?
Answer: 32 bits.
😀
Well, it's true. 😉 ...
September 15, 2015 at 10:00 am
johnsonchase7 (9/15/2015)
This actually works for me. Thanks guys.
Excellent. Thanks for the feedback.
September 15, 2015 at 9:58 am
Lynn Pettis (9/15/2015)
Ed Wagner (9/15/2015)
Eirikur Eiriksson (9/14/2015)
Sorry, slightly hurried and inaccurate😎
CONVERT(DATE,AppDetails.DateDetailDisposed,0) = CONVERT(DATE,DATEADD(DAY,-21,getdate()),0)
If your DateDetailDisposed column is a datetime data type, you might run into a performance problem here. ...
September 15, 2015 at 9:32 am
Viewing 15 posts - 5,146 through 5,160 (of 9,399 total)