I typically avoid optimizer hints as well, but in one particular application I support the optimzer regularly excludes a necessary index and by using the hint performance goes from minutes...

Your date in SQL Server is a datetime datatype and by default VB.NET doe snot pass in teh milliseconds. In order to pass in milliseconds you need to use...

I know this iwll sound like a help desk reply, but have you rebooted since setting up the mail profile? I have seen where this has solved the same problem....

Have you setup a MAPI mail profile (Outlook) for you SQL Server Agent account? Then have you gone into SQL Server AGent properties and assigned this profile?

SQL...

You could use an application role, but even with that, if they know the sa password, they could use that to connect ot the database adn do whatever they want....

I am not an Oracle DBA, but I would not think that you could pass a data table directly into a procedure. One way you might be able to...

I am not sure what you want to do. Do you want to migrate jobs to a new server once or do you want to create a job that...

I have used what I think is a somewhat simpler method for my triggers. The trigger will only fire if there are rows affected so checking for rows...

I am sure that there must be a way, but I don't think you can do it using SQL Server you would have to use VB or a .NET language....

Where are the values coming from? If they are stored in a text document or spreadsheet you could use DTS to import the values into a table and then...

How many rows are being returned by the query? Have you tried forcing the Index? It sounds as though SQL Server has decided that it is faster to...

While this means setting up some things manually I recommend downloading and using SMTP Send Mail which is available at http://sqldev.net/xp/xpsmtp.htm.  I have had multiple problems using SQL Mail...

I have to disagree with Alex.  This is something any SQL Server DBA or developer should know and be able to answer relatively quickly.  We were "caught" by @@identity in...

I found this quote at http://www.mcse.ms/archive85-2004-2-364893.html

Steve 2004-02-06, 11:33 am

Update on this. I have turned...

The server group Server Administrators allows access to sqlagent jobs, but also allows other options.  In order to have them have dbo owhership for the objects they create you should...