Did what you suggested...still throws an error...

Here is the code I tried executing...

ALTER PROCEDURE [dbo].[usp_Names]

(@ID int)

AS

DECLARE @TaskOutFile VARCHAR(255)

DECLARE @SQLQuery VARCHAR(100) = 'select * from Table where ID=@ID';

Select @TaskOutFile =...

ALTER PROCEDURE [dbo].[usp_Names]

(@ID int)

AS

DECLARE @TaskOutFile VARCHAR(255)

DECLARE @SQLQuery VARCHAR(100) = 'select * from Table where ID=@ID';

SET @SQLQuery = REPLACE(@SQLQuery,'@ID',@ID);

Select @TaskOutFile = 'C:\SSIS' +@ID + '.html'

EXEC sp_makewebtask @outputfile =@TaskOutFile , @query...

It still throws an error...

ALTER PROCEDURE [dbo].[usp_Names]

(@ID int)

AS

DECLARE @TaskOutFile VARCHAR(255)

DECLARE @SQLQuery VARCHAR(100) = 'select * from dbo.Table where ID=@ID';

SET @SQLQuery = REPLACE(@SQLQuery,'@ID',@ID);

Select @TaskOutFile = 'C:\' +@ID+ '.html'

EXEC sp_makewebtask @outputfile...

It gives me this error ...

Msg 137, Level 11, State 1, Line 0

[Microsoft][SQL Native Client][SQL Server]Must declare the scalar variable "@ID".

Msg 16805, Level 11, State 1, Procedure sp_makewebtask, Line 131

SQL...

Can I do something like this ?

Get-ChildItem -path $Directory -recurse -include *.txt | ForEach-Object {Start-Process -FilePath $_.fullname -Verb Print -PassThru | %{sleep 5;$_} | kill }

Get-Process | Output-Printer "\\Print1\ABC01"

where ABC01...

.

Can anyone assist me on my above 2 questions regarding autoprinting from SSIS

So when the new root is created it contains 2 pointers to the split up old root(s).Is that right?So each time a new level is added the old root is...

Does the data move to a new leaf level whenever a new extent is created to insert new data which does not fit into the existing extent/page?

Lets say there are...

"If you want to make it user controlled via a report object then you will need to look at writing an external assembly and embedding it into the report."

Would it...

I got the above script working.But now I only have the servername and the version in the database.I would like to have the following details as per the below t-sql.

SELECT@@servername...

insert into Table

SELECT@@servername as Servername,name as DBName,[crdate] AS [LastStartupDate]

FROM[master].[dbo].[sysdatabases]

WHERE[name] = 'tempdb'

and [Test].[dbo].[Table].LastStartUpTime < [master].[dbo].[sysdatabases].crdate

It gives me this error now:

Msg 4104, Level 16, State 1, Line 1

The multi-part identifier "Test.dbo.Table.LastStartUpTime" could...

On SQLServer 2005:

I am in the Test database which has Test table.

insert into Table

SELECT@@servername as Servername,name as DBName,[crdate] AS [LastStartupDate]

FROM[master].[dbo].[sysdatabases]

WHERE[name] = 'tempdb'

and [Test].[dbo.Table].LastStartUpTime < [master].[dbo].[sysdatabases].crdate

Error:

Msg 4104, Level 16, State...

SQL Server 2008 has start time.Where can I find similar data in 2005 and 2000

I would like to have the servername,starttime,login that started the server,login that stopped the server...

Yes.

Just as scott has coded.