I've taken over the job of administering our main SQL instance we use for our ERP application (Dynamics NAV) The install has many files listed in the...
We have a large ecommerce application. The product inventory, order workflow etc... is handled by Navision...
I have a bunch of PhoneDeals in my vDeals view... when i query this, i do something similar to: select * from vDeals where HandsetID = '1234' This...
Hi, thanks for your messages.... i changed the view to use the subquery, however i get this message when trying to add an index to the view: Cannot...
Hi, I've currently got a view, that uses this statement: SELECT DISTINCT h.Name, h.Manufacturer, h.Model, h.HandsetID, h.LaunchDate, h.Features,...
sorry, im not sure what you mean... do you have an example?? alex
long post alert... I have a few tables in my database, which represent data i get from a txt file, which i import every day using bulk copy. there...
Hi, I use the following SQL to import a CSV file- BULK INSERT tableName FROM PATH_GOES_HERE WITH (FIELDTERMINATOR = '|', TABLOCK) works great,...
I have something similar to this: ProductID (int) Yes (Bit) No (Bit) Basically, each row can either be yes, or no... how can i enforce that?
Hi, We have a number of databses that we develop against on our local machines. We constantly swap our ".bak" files between each other, with latest...
Hi there, Suppose i have a data structure similar to below: LocationID LocationName ParentLocationID 1...
up until now, both SQL Server, and IIS were running one one machine. i have bought a new server, running sql server 2000. this machine is called...
This should be a simple error to fix.... but the server is already set to mixed mode... sql & windows authentication any ideas what else could be...
I have upsized an Access database to SQL 2000. I am now in the process of sorting out all my SQL Queries so that they will work on SQL 2000.... one...
Hi guys, my mind has gone blank... the following sql works fine against an access db: SELECT Name, NameLast, CompanyName, Choice, PictureRef,...
Hi there, i have upsized an access database to sql 2000... most of the tables "Autonumber" fields have correctly been created as identity columns,...
yeah, i want one result set... this is already one proc. basically, theres a @query parameter. i want this to be used in both queries, but return...
i have a stored procedure that uses a fulltext search to search descriptions. this is a fulltext catalog. i also have another catalog which catalogs...
no error message, just sits there in enterprise manager saying "population in progress" but theres only about 10 records to index.... been sat there...
Separate names with a comma.
