Viewing 15 posts - 4,036 through 4,050 (of 6,397 total)
Was the binary data uploaded as a jpg or a bmp?
August 8, 2012 at 1:46 am
No, you cannot as it violates logical query processing order.
You would need to build in the DATENAME function or build in the CASE call within your WHERE clause.
Best thing to...
August 7, 2012 at 9:20 am
Nothing, Logshipping issues BACKUP LOG commands like you would do normally.
You have missed one key point out of your process.
When you change the database to SIMPLE, to shrink the log,...
August 7, 2012 at 9:10 am
Lavanyasri (8/7/2012)
Just i am asking him to check both the files in the same drive or different drive??
The mdf and...
August 7, 2012 at 7:30 am
Yes, unless you have some form of auditing, you wont be able to find out the exact time anything happened.
August 7, 2012 at 7:29 am
rajprabuit (8/7/2012)
No.You can't add 2 primary key in a table.Instead u can add Unique key which accept null value in it.
But if the OP wants it to act like a...
August 7, 2012 at 7:28 am
Unless you have an audit table or a trace running, you wont be able to find the exact time.
The best thing to do would be to restore to atleast 10...
August 7, 2012 at 7:27 am
In the CASE where you have GetDate(), replace it with DateEffective
DATEPART(WEEKDAY, dateeffective) = 1 THEN 'Sunday'
But I would do it like
SELECT
...
...
...
DATENAME(dw,dateeffective)
FROM
...
August 7, 2012 at 7:12 am
That because GETDATE is getting the current date and time, therefore as today is Tuesday, they all show Tuesday.
You need to use the dateeffective column instead of GetDate(), also take...
August 7, 2012 at 6:39 am
Lavanyasri (8/7/2012)
5. Check the mdf files and ldf files in the same location
Bad idea, MDF and LDF files should be on physically seperate drives.
August 7, 2012 at 5:27 am
Use the scripts I have given you as a starting point, use Google (other search engines available) or Books Online to look at the syntax of the other options which...
August 7, 2012 at 4:34 am
All you need is the BACKUP and RESTORE commands, plenty of information in BOL or the internet
BACKUP LOG dbname TO DISK = 'some path'
RESTORE DATABASE dbname FROM DISK = 'some...
August 7, 2012 at 4:17 am
Ah, you posted in the 2008 forum, so you got a 2008 answer.
I'm not aware of a 2005 equivilant, but you might find it on google or another search engine...
August 7, 2012 at 4:08 am
You are putting the database name inside the ''
August 7, 2012 at 4:07 am
Viewing 15 posts - 4,036 through 4,050 (of 6,397 total)