Good luck; if yaa find something please post here. I would like to know built in way of doing it so I don't have to find "alternative" methods of...

I wasn't pressing on shortkey ;-).

First time I steped-in using the tool bar button and placed my break points on both SELECT statements.

Then I ran it using Debug mode; and...

Yeap; thats how I did do it.. Orr rather will be doing it on me servers once I get free cycles LOL. I thinks I'll add this bit to...

Can you please paste the T-SQL code your executing?

This is what I execute:

ALTER DATABASE DBName

SET Parther='TCP://Server:Port'

Server Being the Principle Server/Mirror Server.

Port being the Endpoint Port.

Thanks.

It shouldn't cause issue to have these installed together. Because many developers I know have alot of those tools in addition to Developer Edition or full version of SQL installed...

You can use this query to get the name of the log file ...

Output: nightly backup 5pm_Subplan_1_20090309181905.txt

[font="Courier New"]    SELECT SMPP.[name] + '_' + SMPS.subplan_description + '_' +

           CONVERT(VARCHAR(8),end_time,112) +

           REPLACE(CONVERT(VARCHAR(8),end_time,108),':','') +...

*smack* ... I knew I should have drank more coffee ...

>_> Sorry.

We had a consultant who had developed an app in outlook forms. Because we didn't want to pay him to support it; we had to pay him $$$ after...

An interesting example I had ran into ..

[font="Courier New"]SELECT * FROM (

  SELECT

    ROW_NUMBER() OVER (ORDER BY ResourceName ASC) AS rownumber,

    *

  FROM ApplicationResources

) AS foo

WHERE rownumber = 5[/font]

Ref: http://stackoverflow.com/questions/16568/how-to-select-the-nth-row-in-a-sql-database-table

Thanks.

Yaa Jeff go hunt down the 3rd party vendor :). Jeff likes dealing with them hehe.

Yes ....

Although if table exists then you have to do

INSERT INTO OtherDB.dbo.TableName

SELECT ColList, ...

FROM CurrentDB.dbo.TableName

Creating a database doesn't create the user name and password.

You can create a new Server Login with following code:

[font="Courier New"]USE [master]

GO

CREATE LOGIN [test] WITH PASSWORD=N'test123', DEFAULT_DATABASE=[DBName], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF

GO

USE [DBName]

GO

CREATE USER...

Same post, other one has more detailed info; link.

You can use the substring function to select subset of the day with in a string. The table structure doesn't provide much info .. so thats best I can...

Could you post the code? Or attach the SQL file?

Mohit.