Search results for query: *

I've trying to configure a SQL Server 2000 SP4 standard edition for replication to act as a publisher and distributor. When I use the new publication wizard to create the publication I get an error: Could not find stored procedure 'msdb.dbo.sp_add_jobstep_internal'. I've looked about on the...

Having run Index Tuning Wizard against our heavliy loaded database, the recommended index configuration appears to give some strange results. In the Query Cost Report the "percentage improvement in cost" values for the 100 most expensive queries are all large negative values e.g. -96133, -1662...

Whilst running a profile of some SQL generated by an application I came across this: SELECT statman([record_change_status],@PSTATMAN) FROM ( SELECT TOP 100 PERCENT [record_change_status] FROM [dbo].[#Browser____________..._______________0002000004C3] WITH(READUNCOMMITTED,SAMPLE...

I have traditionally tested for the existence of objects such as tables using the IF EXISTS syntax and information_schema e.g. IF EXISTS(SELECT 1 FROM Information_Schema.Tables WHERE Table_Name = 'MyTable') BEGIN ... END But I think this might be a simpler way; IF...

How does Enterprise Manager remember the view settings when you click on a database node? I want to set the default view to be 'Taskpad' for all databases instead of 'Large Icons' but I don't know if this is possible. Might it be in an .ini file or a table in master database? cheers Nathan...

I need a SP or function that will return the size of a physical disk (not just the free space, as given by xp_fixeddrives), e.g. C: 1000MB D: 5000MB Any suggestions? thanks, Nathan [yinyang] ---------------------------------------- Want to get a good response to your question? Read this...

How do I reference Information_Schema in a database on a linked server? If I use SELECT * FROM Server.Database.Information_Schema.Tables for example I get the error: Server: Msg 7314, Level 16, State 1, Line 1 OLE DB provider 'Server' does not contain table...

Can a Paradox 5.X database or free table directory be added as a linked server in SQL Server 2000? In theory it seems to be possible but we are having no success either using EM or sp_addlinkedserver and OLE DB connection or ODBC. Any advice much appreciated! thanks, Nathan [yinyang]

Hi, I want to put the result of running an xp_cmdshell command into a local variable. Is this possible? e.g. execute master..xp_cmdshell 'dir /b d:\Client\Updates\2003\Apr_2003\Data\*19094*.*' returns; MRN19094X20030329.csv Can I somehow store this to a local varchar variable? thanks in...

When I query the global variable which is supposed to contain the name of the local SQL Server e.g. SELECT @@servername it returns NULL instead of the server name. This is supposed to be set during installation. According to BOL I should be able to change the local server name using...

I have created several local DTS packages to update tables in SQL Server from Excel spreadsheets. One of the packages is giving a problem though; I can create an Excel spreadsheet connection by selecting the spreadsheet using the file select dialog but when I try to add a Transform Data task...

Hi, I have come up against a strange (to me anyway) problem in an Excel spreadsheet I am trying to import to SQL Server. When imported, some of the values for cells were NULL although they contained identical values to cells above and below them. I traced the source of the NULL problem to the...

I have an installation of VFP6 and when I create a new project and edit the Builder... options and change the Application Type to Top-Level and click on 'OK' I get the following error; Error number : 12 Method: adjustproperties Line number: 12 Message: Variable 'PROPERTIES' is not found Line...

I have created the following stored procedure but when executed it fails on the update statement indicated due to the LastOrderValue and LastPaymentMethod columns not being present in tmp_OrderDates, apparently because the ALTER TABLE statement has not worked - I am correct in this...

The BOL help for SELECT tells me: "You can use SELECT...INTO to create an identical table definition (different table name) with no data by having a FALSE condition in the WHERE clause." but can anyone tell me what the actual syntax for a statement like this would be? thanks, Nathan

I have a dial up connection to our network from outside, when I connect I am able to run EM and QA (2000) from my client PC and connect to all available SQL Servers on the network, except one. When I try and register or connect to this server I get and error which says "Server does not...

I am using SQL Server 2000 and I've noticed that when SQL Server is displaying a list of available servers e.g. for New SQL Server Registration in Enterprise Manager, or Connecting to SQL Server in query analyser, that only some of the available servers are displayed. Can anyone tell me whether...

Someone has managed to delete the .mdf and .ldf files that contained a database on our system. I have managed to restore what appear to be copies of these files, but I am having problems recreating the database from them. I've tried: CREATE DATABASE MyDatabase ON PRIMARY (FILENAME =...

If you need to produce reports in an electronic format, PDF is a good option. You normally need to have the full version of Adobe Acrobat in order to obtain the PDF Writer necessary to print reports to PDF files. However, if you go to the following website and download the FREE software...

I'm using an application which generates an error of 'Too many names used' after it has processed about 500,000 records. The Help file tells me 'As a program was being loaded or a table was being opened, FoxPro's name table was overflowed. Too correct this divide the program into smaller...