Great place, thank you

Hi, two ways:

A)

/*

SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component is turned off as part of the security configuration for this server....

Hi, here you have doc:

http://msdn.microsoft.com/en-us/library/ms157328.aspx

Hi, maybe interesting for you this doc:

http://msdn.microsoft.com/en-us/library/ms186757.aspx

and

http://www.codeproject.com/KB/database/Building_Dynamic_SQL.aspx

Hi, you could try CASE WHEN statement instead IFF and compare the execution time.

http://technet.microsoft.com/en-us/library/ms181765.aspx

Hi, in your server you'll need to install the netware client service. Control panel - Network - Local area connection - Add - Service - Netware client.

Hi, here is a very interesting article:

http://www.tech-archive.net/Archive/SQL-Server/microsoft.public.sqlserver.replication/2008-07/msg00066.html

Hi, you can create reports with the report designer of Ax 2009 or you can use visual studio 2005/2008 to connect with Ax data directly and create your own reports....

Hi, you need the ibm informix odbc driver.

http://www-01.ibm.com/software/data/informix/pubs/library/csdk_29.html

Next you could create a linked server throw windows ODBC

http://social.msdn.microsoft.com/forums/en-US/sqldataaccess/thread/a89c8f71-c9af-4769-badf-3548faffaa66/

Hi,

A)

MyServer --> BackUp --> MyServerDisk (Every day and month/Backup planning/Jobs)

B)

MyServer --> My(Hard Drive/Tape/DVD-RW/SAN). I'm sure I have a save system for backups

C) I need a rapid DSL line in my...

Hi,

A)

MyServer --> BackUp --> MyServerDisk (Every day and month/Backup planning/Jobs)

B)

MyServer --> My(Hard Drive/Tape/DVD-RW/SAN). I'm sure I have a save system for backups

C) I need a rapid DSL line in my...

Hi,

A)

MyServer --> BackUp --> MyServerDisk (Every day and month/Backup planning/Jobs)

B)

MyServer --> My(Hard Drive/Tape/DVD-RW/SAN). I'm sure I have a save system for backups

C) I need a rapid DSL line in my...

Hi,

A)

MyServer --> BackUp --> MyServerDisk (Every day and month/Backup planning/Jobs)

B)

MyServer --> My(Hard Drive/Tape/DVD-RW/SAN). I'm sure I have a save system for backups

C) I need a rapid DSL line in my...

Hi, you could try to reset the password for the user sa. Look for the auth mode in SQL Server, must be mixed mode for SQL and Windows users.

If you...

Hi, I've find some interesting documentation about jobs. Maybe interesting for you:

http://www.sqlteam.com/article/controlling-jobs-in-transact-sql

http://msdn.microsoft.com/en-us/library/aa260289(SQL.80).aspx

http://www.mssqlcity.com/Articles/Adm/jobs_troubleshooting.htm

http://www.databasedesign-resource.com/sql-server-jobs.html