If you are using 'use nt authentication' on your SQL Server for the user accounts, then on the second config screen of the ODBC connection you need to have the...

Thanks StephenKendrick -

We ended up calling Microsoft yesterday. Very Helpful and Very Thorough in working with me.

Turned out that our sysadmin was installing the operating systems with an image....

I am also having a problem with Insert Exec. Last week we had one server with SQL 7.0 SP4. The local server is SQL2K SP2.When I ran insert...

My wishes(not necessarily in order of desire):

1. Reuse schedules instead of creating them everytime.

2. Allow DTSrun to show the DTS name and not the encrypted name so I can go...

Mostly I can just tell you 'Me too' I have a developer working on a program that seems to be messing up locks. When his program needs an...

I'm still interested in any reponses to this. I have searched support.microsoft.com, sqlservercentral.com, groups.google.com and haven't found any solution.

Thanks,

Michelle

I'm not sure how to change the dbcc inputbuffer, I use SQL Profiler and monitor the SQL:BatchStarting or the SQL:StmtStarting TSQL Events making sure to include the textdata column. ...

I have created linked Server,Server3,using the dialog box in EM. I chose SQL Server as the Server Type on the General Tab. On the Security Tab, I have nothing...

Did you add the account SQLService to the Services on the server yourself or was it done through the Enterprise Manager?

SQL needs some access to the registry for the backups...

Thanks everyone!

This is what I ended up with:

select a.database_name, max(a.backup_finish_date) as backup_date, b.physical_device_name, 'benrosql03' as servername

from msdb.dbo.backupset a join msdb.dbo.backupmediafamily b

on a.media_set_id = b.media_set_id

where right(rtrim(b.physical_device_name),7) = '.sqlbak'

group by a.database_name,...

I've had experience with MTI's SAN equipment and with IBM FastT 700 equipment. MTI's first implementation of the Fiber SAN was slow and very picky. I received promises...

Are you wanting to remove all records from the table or just selected ones?

Truncate table is the best way to go if it is all records due to its minimal...

Can you give a bit more detail? I see two records in the sample with the same URN, Date and UNIT 3692329 2003-01-10 00:00:00.000 3OR but you...

Ok, maybe I'm braindead, but how do I find these UDF's on this site? Did the Admins approve them? I'm in dire need of this functionality.

Thanks,

Michelle

Create a new table for each month's data. Then have your users access the view instead of the individual tables. Then on a regular archive schedule, backup the...