Viewing 15 posts - 1,186 through 1,200 (of 1,409 total)
I guess the outlining is not correct in your view due to a (very) different length of the data in each row. In most text editors tab-stops are pre-defined. When...
May 15, 2013 at 5:02 am
Jeff Moden (5/14/2013)
HanShi (5/14/2013)
** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **I absolutely love that quote.
Thanks Jeff.
And especially on the internet this is...
May 14, 2013 at 11:59 pm
Like Matthew before mentioned, the subsequent criteria is only checked when the previous is failed. You could combine the criteria with an OR statement
SELECT
[Response]
...
May 14, 2013 at 6:46 am
The mail generated by the Job Notification system is predefined and AFAIK it can't be changed. The only way to accomplish your request is to create your own messaging system...
May 14, 2013 at 6:26 am
place the mail procedure inside an IF statement
IF not exists(SELECT * FROM ::fn_trace_geteventinfo(2))
BEGIN
EXEC msdb.dbo.sp_send_dbmail @profile_name = 'DBA Alert',
@recipients...
May 14, 2013 at 5:44 am
No databases will go offline. It wil generate error level 17 messages stating "object xx can't be created in filegroup yy for database TempDB" and the transaction(s) will be cancelled...
May 14, 2013 at 5:32 am
Check the security settings within the Report Server site and add the credentials you use with Visual Studio. Assign "System Administrator" rights to the account.
If you don't have the rights...
May 7, 2013 at 2:50 am
If you create a new AUDIT from SSMS the first window gives you the option to select the destination. The available options are "File", "Security Log" or "Application Log". When...
May 7, 2013 at 2:27 am
You can add a CASE statement and use this to assign a specific value to the row, depending on the condition. By sorting on this value in combination with a...
May 7, 2013 at 2:08 am
Hi,
I'm sorry I misunderstood your problem. I tried it by doing some testing and I was able to reproduce the error.
I created a SQL account and granted all but sysadmin...
May 2, 2013 at 7:36 am
Hi,
On the printscreen with the error message you don't have a filename entered by "Destination on disk". You do have specified a folder, but if you don't add a filename...
May 2, 2013 at 4:02 am
When clicking to the backup folder the filename for the backup is not specified and should be entered manually. You can only click to a file when this (backup-)file allready...
May 2, 2013 at 2:37 am
Easy one 😉
Allthough I got it wrong because I didn't read the whole query :blink: I forgot the " WHERE (SELECT MAX(C1) FROM dbo.T1) > C1" part.
February 28, 2013 at 9:10 am
sorry, a problem with my browser generated a double post
November 16, 2012 at 5:07 am
I guess you have a typo of some kind in the connection string. Can you access and load from the Excel file using the import/export wizard?
When you save the import/export...
November 16, 2012 at 5:07 am
Viewing 15 posts - 1,186 through 1,200 (of 1,409 total)