Viewing 15 posts - 14,011 through 14,025 (of 26,486 total)
yuvipoy (1/10/2012)
Select * from sys.sysobjects where Xtype='p'-- Result is Good
Select * from DBName.dbo.sys.sysobjects where Xtype='p'--Result is
Msg 7202, Level 11, State 2, Line 1
Could not find server 'DBName' in...
January 10, 2012 at 9:08 pm
How often does this database need to be synced? Could the client simply send you an encrypted and password protected zip file of a current full database backup?
January 10, 2012 at 9:05 pm
latitiacasta (1/10/2012)
Thank you all of yousean: can you please elaborate what is dbo.DelimitedSplit8K?
Do a searh of this site for dbo.DelimitedSplit8K. You should find quite a bit of information....
January 10, 2012 at 8:59 pm
First, please write your code using the ANSI-92 style joins, not the ANSI-89 style joins. Putting your join criteria in the FROM clause and your filter criteria in the...
January 10, 2012 at 8:50 pm
Yes, you can run reports (read-only) against a database in standby mode. No, you can't apply transaction logs while reports are running against the database in standby mode, you...
January 10, 2012 at 8:37 pm
How about saving your actual execution plan and uploading it to this thread? That would help us a lot.
January 10, 2012 at 8:33 pm
SQLRNNR (1/10/2012)
Based on this being related to leads, how large are the tables involved?Please provide the execution plan too!
Agreed, and it should be the Actual execute plan if possible...
January 10, 2012 at 8:24 pm
Eshika (1/10/2012)
January 10, 2012 at 8:17 pm
Need the ddl (CREATE TABLE script) for the table including the definition for the trigger. If the trigger affects any other tables we will need those also.
January 10, 2012 at 4:31 pm
Case insensitive vs case sensitive, one of the reasons I write all my queries and t-sql code as if everything was case sensitive. Don't have to worry about it...
January 6, 2012 at 7:48 am
Ninja's_RGR'us (1/5/2012)
Steve Jones - SSC Editor (1/5/2012)
In terms of depreciation, it sucks, but it's real. The value of your stuff is lower over time, and if you had to replace...
January 5, 2012 at 9:55 am
Ivan Mohapatra (1/2/2012)
so we can not have compare condition in image datatype...
January 2, 2012 at 11:48 pm
This may be what you are attempting to accomplish.
delete from dbo.phototable
from
dbo.Master_table sod
inner join dbo.phototable p
...
January 2, 2012 at 11:54 am
GilaMonster (1/2/2012)
MyDoggieJessie (1/2/2012)
I've got a log reuse type of LOG_BACKUP, but there's no transaction log backup running.Please post new questions in a new thread. Thank you.
I agree with Gail...
January 2, 2012 at 11:36 am
Viewing 15 posts - 14,011 through 14,025 (of 26,486 total)