blacklabellover2003 (10/26/2012)

---

Hi all,

I have an orphaned .mdf + .ldf fileset on our production box, I know how to attach them.

But I also need to find out who the last user...

can the two servers see each other, like on the same network or anything like that?

you could set up replication for preocedures, but i'm not sure the master database can...

if you've created your own procedures, and then marked them as system procs, it's easy.

1.you still script them like always (sp_helptext procname, or script them in the GUI.

2.Create them in...

exec sp_fkeys TableName will list all the relations for a single table, if you want to use that as a basis for a script.

I think the core issue is parenthesis.

Because of the other two conditions the results still have the values he was trying to filter out.

and/and/or needs to be handled ,

fixed. i...

is your data really ending in CrLf, or could it be a file form UNIX, where it's ending in just CHAR(10)? (LF)?

that would explain the errors.

I've always handled this with a Calendar table, where the Calendar table has DaylightSavings column.

that is especially important if you fiddle with historical data, because the date ranges for DST...

if the database is restored automatically each day, the easy solution is to add to teh current script, so that after teh restore, the mapping you need is performed.

if it's...

Great job on providing the setup of the data.

by simply comparing the length of the string against the length of the replace of periods, you get the # of periods...

your data is not just split by commas, is the issue; they are delimited or "Text Qualifed" with single quotes.

to handle taht gracefully, I think it is much...

britinusa (10/25/2012)

---

Did Google this first and it seems some SQL 2005 do not have the Design option.

So one literally has to run an ALTER rather than in 2000 where...

bulk insert does not automatically fire triggers unless you specifically set the flag (FIRE_TRIGGERS ).

I'm not sure your trigger is not designed to handle multiple rows correctly.

if i...

Andy Let me know if this helps at all.

What i usually do in that specific situation is to create a sql user, without login on the linked server that...

how many chances at this do i get to make it right again?

select

[active_end_time],

val ,

val + CASE WHEN CONVERT(int,SUBSTRING(val,1,CHARINDEX(':',val) -1)) > 11 THEN ' PM' ELSE ' AM' END...