Viewing 15 posts - 24,136 through 24,150 (of 26,490 total)
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.
π
October 13, 2008 at 1:33 pm
Have you tried this:
ALTER DATABASE [SharePoint_AdminContent_1f7d4d63-662f-4180-a6b9-7d4b35b27435]
MODIFY FILE ( NAME = SharePoint_AdminContent_1f7d4d63-662f-4180-a6b9-7d4b35b27435_Log,
...
October 12, 2008 at 10:54 pm
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...
October 10, 2008 at 11:46 am
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
...
October 10, 2008 at 11:09 am
Learn something new every day on this site!
Keep up the good work, Steve!
π
October 9, 2008 at 1:27 pm
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...
October 9, 2008 at 12:03 pm
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...
October 8, 2008 at 9:34 am
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,...
October 8, 2008 at 9:03 am
I'm waiting to see why you need to change the case of everything in your stored procs from UPPER CASE to lower case.
π
October 8, 2008 at 8:49 am
rbarryyoung (10/7/2008)
Jeff Moden (10/7/2008)
October 7, 2008 at 11:05 pm
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...
October 7, 2008 at 2:32 pm
I'm poor and don't have an MSDN subscription, so I pay "retail" for the developer edition.
π
October 7, 2008 at 1:19 pm
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. ...
October 7, 2008 at 1:17 pm
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...
October 7, 2008 at 1:13 pm
mesql (10/7/2008)
I want to update modifieddate to todayβs date when every there is a modification...
October 7, 2008 at 10:32 am
Viewing 15 posts - 24,136 through 24,150 (of 26,490 total)