How about writing a little code that issues xp_cmdshell "OSQL" commands and uses the -o option to output the data to a file for each of the 100 tables.

Gregory Larsen,...

I really don't have a good explaination, but I'm guessing it has to do with building an execution plan at compile time. If you try to use a variable...

You will need to use dynamic sql something like this:

declare @top int

declare @cmd varchar(1000)

set @top = 10

set @cmd = 'select top ' + cast(@top as char) + ' * from...

Yes there is. Here is a some code I built and put in a job step, which is scheduled hourly. If this job notices less than 1 gig of...

When you run this from the command shell are you logged on with the same account being used by MS SQL Server Service?

Gregory Larsen, DBA

If you looking for SQL Server...

That isn't what I would expect.

Can you put a "GO" prior to the truncate table so it is two different transaction?

If so I'm thing then for sure...

Couldn't you rewrite this to be something like this:

CREATE PROCEDUER sp_something

@name VARCHAR(15) = NULL,

@phone VARCHAR(17) = NULL,

@dateupdated DATETIME = NULL

AS

SELECT name, phone, dateupdated

FROM TABLE1'

WHERE (name = COALESCE(@name, name) or (name...

We are running IIS 5.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Thank you for the links and the information Brian. My goal here is to use Windows Authentication. Most of our application use a single SQL Server login for all...

Brian, it is my impression that you can't use Integrated windows security to perform double-hop authentication. Meaning if a client is logoned on as a domain user, and the...

I'm looking to determine if DBA's are throwing this onto PRODUCTION Servers ASAP, or are they using some caution in rolling this out. What implementation strategy are most shops...

What account is associated with the SQL Agent service? Is that account a member of SYSADMIN?

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at...

For SQL 2000 you have to change your recovery options to "Simple" with is similar to the SQL 7.0 "Truncate log on checkpoint"

Gregory Larsen, DBA

If you looking for SQL Server...

Right click on database, select "Properties", look under the "Options"

tab and you will find "Truncation Log on Checkpiont" option. I think I might review what this means prior to...

You will need to use the convert you float data to varchar when selecting your float data. Should be something like this

cast(float_field as varchar(5))

Gregory Larsen, DBA

If you looking...