Viewing 15 posts - 42,016 through 42,030 (of 49,571 total)
Untested, but I think something like this should work.
IF EXISTS (SELECT 1 FROM inserted WHERE siteID IS NULL)
UPDATE Sites SET siteID = sectorCode + CAST(pkSiteID AS NVARCHAR(5))
FROM
Sites INNER...
January 4, 2009 at 12:07 pm
Jody Claggett (1/4/2009)
Actually, what I have come to find out is that 2008 and 2010 are minor releases, which means the major portion of the engine hasn't changed.
SQL 2008...
January 4, 2009 at 11:34 am
DBADave (1/4/2009)
We have a 100+GB database that eventually with grow to 500GB+.
A 100GB database is not large. Even a 500GB doesn't qualify as very large.
Reindexing takes a...
January 4, 2009 at 9:06 am
parth83.rawal (1/4/2009)
Hope this will do.
Please read the article that I posted about how to post sample data and table structure.
January 4, 2009 at 6:42 am
John Marsh (1/4/2009)
Hello,Was there not a “State: NN” part to the Error Message? The value for State is important in determining the exact reason for Logon failure.
State'll be in the...
January 4, 2009 at 4:06 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 4, 2009 at 3:38 am
george sibbald (1/3/2009)
January 4, 2009 at 3:36 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 4, 2009 at 2:48 am
iqtedar (1/3/2009)
but wat should he do if he needs to reduce the log file size..thanks in advance and wish you all a very happy and prosperous new year..thanks
A once off...
January 4, 2009 at 2:35 am
madhu.arda (1/3/2009)
January 4, 2009 at 2:29 am
It could be that someone's done an adhoc backup to a drive other than Z. Use the following to see the backup history.
select * from msdb..backupmediafamily
January 3, 2009 at 12:11 pm
waykna (1/3/2009)
I omitted the ORDER BY, given that there's an index on the two PK fields being selected.
An index is not a guarantee of the order of the data returned....
January 3, 2009 at 11:17 am
I finally managed to get everything working again, and have a look at your procs. There's a few things I noticed that could be potential problems.
fnGetTerrTree_2:
FROM Users
CROSS APPLY (
SELECT v.TerriId
FROM...
January 3, 2009 at 9:59 am
ColumnName LIKE '%/%' ESCAPE '/'
With a character defined as an escape character, any character that follows that in the LIKE will be treated as a literal value.
January 3, 2009 at 9:51 am
Roy Matthews (1/2/2009)
I'm getting the same problem. What is the solution to this?
All data access via stored procedures, grant only execute permissions on the procs and no rights to...
January 3, 2009 at 7:48 am
Viewing 15 posts - 42,016 through 42,030 (of 49,571 total)