Viewing 15 posts - 271 through 285 (of 596 total)
Jacob, once you link the SQL Server tables, they show up in the list of tables along with any Access tables - they just have different icon to indicate they...
February 9, 2006 at 11:44 am
How about suser_sname() ? It works for both Windows and SQL logins, although the Windows accounts are prefaced with the domain name.
February 9, 2006 at 11:32 am
Another user on this forum received the same error message as you do. The cause was a descending order index on the oracle table. Apparently, that is not supported by the...
February 9, 2006 at 11:25 am
Are you sure the paths you specified for the master database (master.mdf) and the master log file (mastlog.ldf) are the correct ones? All of the information for your other databases...
February 9, 2006 at 11:16 am
Sorry, I don't use Oracle, but I searched BOL with this string "ole db provider for oracle". According to BOL:
Each Oracle database instance has only one catalog with an empty...
February 9, 2006 at 10:04 am
You could check the registry on the server for this key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters
There will be several SQLArg's (SQLArg0, SQLArg1, etc). Note the paths there. Verify the folder locations of your data files...
February 9, 2006 at 9:36 am
Your query contains:
EMAXDEC1..MAXIMO.WORKORDER AS wo
EMAXDEC1..MAXIMO.EQSTATUS AS es
The fully-qualified format is SERVER.DATABASE.OWNER.TABLE
You have left out the database name. The Schema is MAXIMO.
Try including the database name between the
February 9, 2006 at 9:22 am
SET @mySQL = 'usp_MyProc ' + Convert(nvarchar(20), @SchoolID) + ', ''' + 'DATA IMPORT' + ''''
--or--
SET @mySQL = 'usp_MyProc ' + Convert(nvarchar(20), @SchoolID) + ', ' + '''' + 'DATA...
February 8, 2006 at 7:42 am
Instead of:
if(select count(*) from VW_CUSTOMER > 0)
try:
if (select count(*) from VW_CUSTOMER) > 0
-or-
February 8, 2006 at 6:36 am
You never did say what version and edition of SQL Server you are using nor what operating system you are running. I'll assume SQL Server 2000.
Do you know the sa password? If...
February 6, 2006 at 11:02 am
If you use the yyyymmdd format, it will always work regardless of the regional settings or SET DATEFORMAT state. Plus, no U.S. month names, just numbers. Since today is Feb...
February 3, 2006 at 11:39 am
(SQL Server 2000)
Since XML is just text, forget the image type. I'd probably use the text type.
If you need to use Unicode characters, use one of 'n' types such as ntext or...
February 3, 2006 at 10:55 am
Another way is to add a /a switch to the EM startup command. This activates "author" mode. You will be prompted to save changeswhen you quit.
What I usually do is...
February 3, 2006 at 10:39 am
DBMSSOCN was part of SQL Server 7. It is not used with later versions of SQL Server. Since the default library is TCP/IP, the above suggestion should work.
February 2, 2006 at 10:38 am
I assume you mean you want to register the server in Enterprise Manager (EM). Registering the local server as (local) in EM can
be done regardless of the server name...
February 1, 2006 at 7:00 am
Viewing 15 posts - 271 through 285 (of 596 total)