As far as I understood the question, the OP is asking to display the results in two different tabs like Results1,Results2, and so on inspite of in the one and...

SqlConnectionStringBuilder.AttachDBFilename Property

Gets or sets a string that contains the name of the primary data file. This includes the full path name of an attachable database.

Atif Sheikh

When you use Auto_Fix, you must specify user and password if the login does not already exist, otherwise you must specify user but password will be ignored. login must be...

Truncate Table command is logged but deallocation of pages is recorded, NOT the row level datya as in Delete command and Data is NOT recoverable after Commit.

In case of...

The tool used to make the video is cool. Also, great learning stuff for the beginners.

Atif Sheikh

Try Using APEX Sql DOC for data dictionary and VISIO for creating the diagrams and alot more. APEX SQL Studio has the diagram (have to check this out...)

Atif Sheikh

MSDN, Books Online and Google are your best companions.

ALOT of stuff ot there... All you need is TIME...

Atif Sheikh

And I would be waiting for the SQL Server BUG. 😀

Atif Sheikh

I dont know about the bug found in the SQL Server 2005. But I need to clear a couple of things over here,

1. The variable @ReturnID id NOT...

I simply added begin and End in the Else part and did some of the changes as shown below...

ELSE

begin

--==== If The file does not exist process...

I dont think there is any way to return message from the trigger.

Can do this from the sp using raiserror.

Atif Sheikh

sp_send_dbmail stored procedure is in the msdb database. For this reason, you have to provide the databasename, SchemaName and Objectname in order to hit the right object.

Atif Sheikh

The tempdb is re-created every time you restart SQL Server.

If you need to Shrimk the tempdb, see the following link...

http://support.microsoft.com/kb/307487

Atif Sheikh

You are absolutely right. Can use CASE as;

Declare @YourVal as varchar(12)

Set @YourVal = 'V1GFG04 - Luis '

Select case Charindex('-',@YourVal) when 0 then 'what ever you want' else Left(@YourVal, Charindex('-',@YourVal)-1...

101 % right... I wonder why I didnt think of it. Thanks

here it goes...

Select Top 1 TrainingPlanID from

...