Viewing 15 posts - 4,786 through 4,800 (of 7,191 total)
That's a US format date. It could be that the account that is running your package interprets it as a European format date. Make sure that the language...
January 30, 2012 at 8:01 am
Does the SQL Server agent service account have permissions on the .xls file? Also, is S a mapped drive? The service account won't be able to see it...
January 30, 2012 at 7:31 am
Does the SQL Server agent service account have permissions on the .xls file? Also, is S a mapped drive? The service account won't be able to see it...
January 30, 2012 at 7:30 am
Stewart "Arturius" Campbell (1/27/2012)
KWymore (1/27/2012)
One thing to note. Answer 2 and 3 don't match the case for columns "name" and "componentname" as declared in the example code. Since I know...
January 27, 2012 at 4:31 am
In SSMS, if you look at the Storage tab on the properties of a table, you can get the row count for that table. If you use Profiler to...
January 25, 2012 at 4:27 am
no need to move system databases. is there any specific requirement? you can script out the logins , permissions and Sql jobs and deploy it to your new partition.
Please...
January 25, 2012 at 4:22 am
I don't know any way of doing that, but it should be fairly simple to set up, something like this:
SELECT 'USE ' + name + CHAR(13) + CHAR(10) + '...
January 25, 2012 at 3:26 am
Join the table to itself on SSN = SSN and Contract_Number = Contract_Number + 1. You can then use DATEDIFF to get the differences between the times.
John
January 24, 2012 at 8:58 am
You shouldn't (and indeed I believe you can't) update system tables directly. Use the stored procedure instead - it's called something like sp_addjobschedule.
John
January 24, 2012 at 8:56 am
guruprasadurs (1/24/2012)
Is that possible to take back using maintenance plan in network drive or ftp server. If possible how to?Thanks in advance
Network drive, certainly. Use a UNC path and...
January 24, 2012 at 7:11 am
Have you tried DENY DELETE ON TableName TO LoginGen on all tables?
John
January 23, 2012 at 4:35 am
What is the size of your model database? DBCC SHRINKFILE won't shrink your database any smaller than that.
John
January 20, 2012 at 2:40 am
raotor (1/18/2012)
Did you get the actual attachments?
No, there's nothing attached to your previous post. Click on Edit Post and then click on Edit Attachments to start uploading them.
John
January 18, 2012 at 4:01 am
Can't see those report files.
You are using SQL Server 2998, aren't you?
John
January 18, 2012 at 3:48 am
You need to use it, for example, if you have a code block longer than one line to be executed (or not executed) in an IF construction. Otherwise, it's...
January 18, 2012 at 3:30 am
Viewing 15 posts - 4,786 through 4,800 (of 7,191 total)