Or you can use the undocumented extended stored procedure xp_readerrorlog, if you have auditing set up.

John

The + operator doesn't work with text data types.  I would suggest you change the column to varchar (surely you can't need over 4000 characters for a file path?)  If...

Works for me.  What data type is the gdetail column?

John

UPDATE heatgen

SET gdetail = 'H:\2007' + RIGHT(gdetail, CHARINDEX('\', REVERSE(gdetail)))

This is fairly basic stuff - I recommend that you spend some time learning the fundamentals of T-SQL, since you are...

Alex

Different types of objects have different ways of generating the scripts.  Views, stored procedures and functions are similar, but constraints, indexes, tables and users are different.  Your best bet is...

OK - that's why I asked at the beginning whether all the files were in the same place.  It seems your problem is more complicated than it appeared.  What you...

That's because it's doing what you told it to: it's replacing every instance of "C:\" with "H:\2007".  So what you need to do is include more than just "C:\" in...

Then I'll leave the rest to you: look up the REPLACE syntax in Books Online.  If there's any aspect of it that you don't understand, please let us know.

John

Are all your files in the same folder on the C drive, or are they spread over more than one?  If they're in the same one, you are on the...

Meeta

You will probably find it enlightening (and also maybe a bit bemusing) to read this article and the discussion that followed it:

http://www.sqlservercentral.com/columnists/dpeterson/lookuptablemadness.asp

John

Peter

This may help you:

http://msdn2.microsoft.com/en-gb/library/ms173423.aspx

Since schemas and owners are different concepts in SQL Server 2005, you shouldn't try to change the "owner" of a view to information_schema.  And if you...

Nathan

To get a domain set up, you'll need to speak to your network administrator.  In the meantime, your best bet is probably to do all your testing on one computer.

John

Dean

Something like this?  I haven't tested it.

John

SELECT e.Employee, a.ChildName, a.ChildSex, a.Age

FROM EmployeesChildren e JOIN

(SELECT Employee, ChildName, ChildSex, Max(ChildAge) as Age

FROM EmployeesChildren

GROUP BY Employee, ChildName, ChildSex) a

ON e.Employee =...

Nathan

I think I'm right in saying that you can't put local users from one computer in a local group on another.  If you have a domain, create a global group...