Ok try this, could be an internal permission issue with the package so create a Agent job that does an insert only to a table when executed that is not...

First the only way I know of to reinstall Agent is to reinstall SQL (which I would make a backup of the databases beforehand). Next reinstalling may not help as...

Not that I am aware of. The only thign I could think of is to do a Select on master.dbo.sysprocess and look for program_name like '%Office%' or '%Access%', which there...

I have dabled here and there with delphi and own version 1 and 2, but I am (not necessarily pure MS) VB, C, C++, VBScript, JavaScript, JAVA (Not too much),...

I went down this route with one of our developers here and we decided to make a compromise that you might want to consider for the shear impact of admin....

Unfortunately no. There is no way that I am aware of directly to import SP from Oracle to SQL, and I haven't seen any third party apps due this yet...

...the C programmers ask you what you been smokin'.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

On the last tab you can specify parameters, for include and exclude on the trace properties dialog. You can set a specific DBID (which you can get by "SELECT [id],...

How are you accessing the database (ADO, ODBC), I have had very little issue with using AS in my queries thru ADO with SQLOLEDB.1 as provider.

Also as for formatting I...

First don't worry too much about tempdb it pretty much lives it's own way. I usually leave dynamic with a minimum of what I know a weeks growth will be...

Actually Steve today I may have found a reason to rethink the whole convert thing. I have been adamant myself on CONVERT(VARCHAR,DATEVAL,101) as opposed to the whole cast thing due...

I forget but there is a maximum number of tables and views that can exist. Also this would be a nightmare to admin so I will never try personally. However...

Crystal is somewhat of a bane to get to work properly. Check out http://www.crystaldecisions.com for their knowledge base and self help. Otherwise it makes it hard without looking at the...

Ahh, I do agree if it wasn't for the fact this whole domain is SQL Servers only, sorry I should have clarified. And there are only 4 machines besides the...

ANswer is no, I cannot find anything to do this. Also sp_RefreshView is actually an extended stored procedure so I cannot see if there is anything you could add to...