Viewing 15 posts - 4,036 through 4,050 (of 6,401 total)
Unless you have custom monitoring in place which captures blocking you will not find the information you require.
August 8, 2012 at 2:00 am
Could you not use something like group policy to install the client at logon time to the machine if its not already installed?
Do you not have any remote software depolyment...
August 8, 2012 at 1:57 am
fakedon63 (8/7/2012)
I already use MySQL so I am already familiar with using SQL
Dont confuse MySQL with MSSQL, they are two very different products and somethings that work in MySQL dont...
August 8, 2012 at 1:53 am
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
Viewing 15 posts - 4,036 through 4,050 (of 6,401 total)