I don't know what I'm missing but when I highlight a package, right-click and select 'all tasks' I just get the regular import/export wizard.  Is there a way to import and...

If you are using SQL Server 2000 you could also create a package and use the 'Execute Package Task'.  This task allows for the transfer of values between the inner...

"....if you get back null or an error on a table you know exists then you could assume the login has failed. "

Sadly, no.  If you query it and it...

Not really because you can define a linked server and a linked server login but that's no guarantee that the login works on the server you are linking to.

There are tons of these scripts using different methods and collecting different types of data.

Check out the scripts on this site.

One of the fun things about when I used to work construction was the little tricks you learned from the 'old' guys.  When you plug something into an extenstion cord tie a...

Have you tried looking in the RDL for the offending parameters and manually chopping them out?  It may destroy your report so save a backup copy.

As I recall when I ran a profile trace on the taskpad view in Enterprise Manager it queried the system tables directly in order to get that information.

You might double-check...

Allen:  Well that makes life a little simpler doesn't it!

Frank:  I'm not sure if you would necessarily call this production code.  Yes, it will be on a production server.  But,...

How about building a pause into the stored procedure?

Have it run the proc which then pauses for a minute or so before executing the actual proc code.  Not that I know...

Well, actually amachanic you got it crooked.  The laundry list I spoke of didn't actually include your post.  It was about coding and backups.  However, since you painted a big...

I don't think techie specifics should be included in a code of ethics for other than example reasons.  When you look at normalization, codds rules, good code etc they don't...

You rock, man!

"I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"

(Memoirs of a geek)

Thanks Steve! I've been dying for a peek at Yukon.

The question I have about the SQL Workbench interface is how does it perform compared to MMC. I've noticed...

I found a bunch of articles on it but was hoping for something with pictures.

I also seem to recall having heard that we will be able to write in T-SQL...