Hey Jeff, I remember reading a post where you loaded in...

mazzz (6/20/2009)

---

Happy Saturday, everyone

I appear to have won a year's licence for Quest's Spotlight for Sql Server, after filling in my details at their booth at the SQLBits conference!

Does anyone...

dh (6/18/2009)

---

I'm trying to pull data from a table that has nulls into a table and field that does not allow nulls, using 'insert into':

insert into myTable

select

e_id...

VM (6/18/2009)

---

declare @table table (id int, [name] varchar(20))

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)

---

Hello,

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)

---

I am using SSRS 2008 and need to create a report that prints labels. The label stock is 2 wide and 4 tall. How is this accomplished...

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)

---

Hi,

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...