It might help if we could see the actual code you are working with else wise all we can do is guess at what may help you.

😎

Have you tried this:

ALTER DATABASE [SharePoint_AdminContent_1f7d4d63-662f-4180-a6b9-7d4b35b27435]

MODIFY FILE ( NAME = SharePoint_AdminContent_1f7d4d63-662f-4180-a6b9-7d4b35b27435_Log,

...

Have to agree with the others. I can't even get SQL Server to show a time different than the server installed on.

I think something is missing from your description...

Give this a try in a test environment first:

update dbo.table1 set

LogonStaffNo = t3.LogonStaffNo

from

dbo.table1 t1

inner join dbo.table2 t2

...

Learn something new every day on this site!

Keep up the good work, Steve!

😎

Are you asking if you can restart the restore from the point of failure? No. You have to restart the restore from the beginning of the process.

(But then...

Broken record time. I wouldn't waste my time reformatting stored procedures just for consistency purposes. I would spend my time on more productive efforts that will have a...

I have to deal with the same thing where I work. If I need to modify a procedure, that is when I make any changes to formatting (capitalization, indention,...

I'm waiting to see why you need to change the case of everything in your stored procs from UPPER CASE to lower case.

😎

rbarryyoung (10/7/2008)

---

Jeff Moden (10/7/2008)

---

Heh... some guy had a problem with one of his renegade developers and he asked what he should do about it. Having dealt with a pod...

Here's the fall back, "it depends". How wide are the records in the heap/clustered index, how many records in the table, how many records are being returned by the...

I'm poor and don't have an MSDN subscription, so I pay "retail" for the developer edition.

😎

True, Gail. I remember, however, when SQL would ignore the indexes entirely if you started a LIKE clause with a wild card and just do a table scan. ...

I have to agree with the other posters. I would also look at changes to the entire process over time. This procedure is RBAR (a Modenism for Row...

mesql (10/7/2008)

---

I have a table called [dbo].[timedes] with 5 columns (id, lastname, firstname, status, modifieddate)

I want to update modifieddate to today’s date when every there is a modification...