dh (6/18/2009)

insert into myTable

select

e_id...

VM (6/18/2009)

insert into @table values(1,'SQL Server 2005')

insert into @table values(2,'SQL Server 2005')

insert into @table values(3,'SQL Server 2005')

insert into @table values(4,'SQL Server 2005')

declare @id int

select...

Well, to check for a table's rowcount being > 0, I would try this:

if exists (select 1 from table)

execute master..xp_cmdshell ...

digitalox (6/17/2009)

I have a temp table that shows up daily in the missing indexes report, provided by the performance dashboard report. The problem is that it in the form of...

This link might help you find what you're looking for.

You're making it harder than necessary.

select * from temp

order by speed desc, acc, tyre, fname, lname

No, it's not a bug.

Before you run step 3 again, right-click on the table and select "Refresh".

Then, when you run step 3, you'll have the column.

The GUI tool (SSMS) only...

Not directly, but there is an indirect way.

Create a temp table with columns that match the data types of the columns being selected in the procedure.

Then:

insert into #MyTempTable

...

vmon (6/17/2009)

You're specifying an empty string for the row terminator, but it looks like your file has a normal CRLF. So, just take out the rowterminator clause.

rambilla4 (6/17/2009)

I want schedule to run sql server profiler in sql server 2005. But I did not find any option. I want schedule to run the profiler from 8:00AM to...

Luke L (6/16/2009)

Same here, getting updated lists...

Jeff Moden (6/15/2009)

WayneS (6/15/2009)

..... getting out the reciprocating saw .... or will that cause too much damage where the...

Check out this article: http://www.sqlservercentral.com/articles/Integration+Services/61542/

..... getting out the reciprocating saw .... or will that cause too much damage where the handrails are installed...