Viewing 15 posts - 106 through 120 (of 201 total)
Consider using SSIS for this. You can automate the process by using WMI event handlers.
All the details are available in Books Online, but you might also find more accurate answers...
May 30, 2008 at 2:27 am
Please post proper DDL and sample data - a script that we can use to reproduce the tables and data.
A few suggestions:
1) Consider using one of the two standard and...
May 30, 2008 at 1:53 am
Oh, I see what you mean. Personally, I alias objects if the same object is referenced more than once and/or when referencing table variables.
And I never (intentionally) claimed that using...
May 22, 2008 at 3:24 pm
I can't imagine not remaining calm. 🙂 Must be the lawyer in me... 😉
Roy Ernest (5/22/2008)
I liked the way you kept your cool. I am not sure why...
May 22, 2008 at 3:05 pm
Either way, I think the OP just needs to exclude database snapshot files and any files created by DBCC operations from being backed up. 🙂
May 22, 2008 at 12:35 pm
Ok, but also consider the warning in Books Online regarding these settings. You don't want any unpredictable results, do you?
May 22, 2008 at 10:03 am
Settle down.
You said:
In update statement derived table is not allowed ...
I say you are wrong, and here's the proof:
create tableA
(
AIDintnot null
,AValuevarchar(128)not null
)
create tableB
(
BIDintnot null
,BValuevarchar(128)not null
)
insertA
(
AID
,AValue
)
select1 as AID
,'this should be in...
May 22, 2008 at 6:31 am
shamshudheen (5/22/2008)
Matija Lah (5/22/2008)
shamshudheen (5/22/2008)
In update statement derived table is not allowed, alternate you can use temp table to store derived table record and then you join the temp tablebye
That's...
May 22, 2008 at 5:18 am
shamshudheen (5/22/2008)
In update statement derived table is not allowed, alternate you can use temp table to store derived table record and then you join the temp tablebye
That's simply not true....
May 22, 2008 at 2:30 am
Isn't the answer worth so much more if you find it yourself? 🙂
Anyway, next time post back with what you've learned, so that others may learn from you.
May 21, 2008 at 2:54 pm
Check the settings for the linked servers and look up sp_serveroption in Books Online. Pay specific attention to the "collation compatible", "use remote collation" and "collation name" setting.
Depending on the...
May 21, 2008 at 2:51 pm
Are you perhaps trying to backup database snapshots files? That's not supported. Does your backup SW support SQL Server 2005? IMHO it should be aware of this limitation.
May 21, 2008 at 5:00 am
The UPDATE...FROM syntax is not ANSI standard, and is only supported on SQL Server. It relies on the assumption that the criteria used to join two ses result in a...
May 21, 2008 at 3:04 am
Viewing 15 posts - 106 through 120 (of 201 total)