I do not believe so

If I recall correctly

ReportServerTempDB exists because it's used as temp table/db by the Report Server, especially snapshots

it doesn't use the native tempdb that's session-only

so there is...

I'd suggest trying a different port

I thought port 1434 is used by SQL Browser, but that's UDP

Red Gate SQL Compare (along with free Snapshot utility)

or xSQL Object

or script out the database and compare in VersionControl system

etc...

Lazy me, I setup SQLH2 (from Microsoft) to collect it for me, both the WMI perf counters and SQL stats

This is what I got from SSMS 2008, similar idea

I usually always use the SSMS to configure full-text (right-click on the catalog to configure, or right-click on the table the...

Interesting, this week I tried shrinking tempdb data & log to clear up some space (just trying for fun, as restarting SQL Server was more difficult to achieve). Data is...

Are you asking how to grab your own Domain name, or other users?

If you're logged in as SQL authentication mode, I don't see how it call your domain info

If I'm...

I would entertain using

1. SSIS with built in FTP tasks

2. xp_cmdshell with external batch file (say ftp_upload.bat)

therefore you edit all FTP operations in the batch file, independent of T-SQL

I always assume it means empty string

'' = EMPTY (not the same as NULL)

' ' = 1 space

I know in SQL 2000 there are some tables

In 2005/2008 I am not certain

but Maint. Plans will be stored in MSDB, if you log in using Integration Service you'll see...

This probably belongs in the SSIS 2005 forum?

http://www.sqlservercentral.com/Forums/Forum148-1.aspx

It's most likely you have to call the batch commands to check for the text file regularly, then if found, run the job

http://www.kodyaz.com/articles/read-text-file-using-xp_cmdshell.aspx

http://www.simple-talk.com/sql/t-sql-programming/reading-and-writing-files-in-sql-server-using-t-sql/

Jeffrey Williams (12/9/2008)

---

Jerry Hung (12/9/2008)

---

It will work for SQL 2005 as well if we change

Select db_name()

,object_name(s.object_id) As ObjectName

...

2 options for restoring LS DB on the Secondary Server

NORECOVERY mode - it's not accessible, period, continues to restore future TLOGS

STANDBY mode - read-only, continues to restore future TLOGS

Log Shipping...

I think a clear flow of business logic would help here

how did you come up with the order below?