I think your approach is ok.

>I'm currently thinking of going with views linked to the new >customer database, to replace the existing customer tables.

if all the databases are on one...

when you use convert just make sure to specify 120,121 or 126 for the date format. some time back i used 103 for comparison and i ended up getting logical...

Which route to take also probably greatly depends on the organisational policy.if you want to have strong password checks, logout etc then WA is the one to choose.

It takes more...

yes you can use WA.as Julian has said the username/password combination has to exist on the other end.

I think it is a good idea to have the anti-virus because the alternative will not be good when your svr is attacked.

i have anti-virus on my dev server, and...

thanks

thanks for the link.i wonder where we will eventually end up with these certifications.

/*add the user to the sql login */

EXEC sp_addlogin @username,@Password,'pubs'

EXEC sp_grantdbaccess @username,@username

refer to BOL for explanations

found this article using c#

http://www.codeproject.com/cs/database/ImageSaveInDataBase.asp

i usually use this

--------------------------

ALTER procedure [Sales by Year]

@Beginning_Date DateTime, @Ending_Date DateTime AS

SELECT Orders.ShippedDate, Orders.OrderID, "Order Subtotals".Subtotal, DATENAME(yy,ShippedDate) AS Year

FROM Orders INNER JOIN "Order Subtotals" ON Orders.OrderID = "Order Subtotals".OrderID

WHERE...

I think you should get one of the books from MS press. The brain dumps are not really good for you (well maybe except for passing the exam) because you...

I think the big guys who support the open source paradigm have seen that there is no way to run away from closed source becoz that is where the big...

eish wish i could also say the same about the zimbabwean situation.we also call it braai this side, but i think soon it will be we used to call it...

I suggest a good book on sql server 2000, it will help you a great deal.

on the SQL Server name dropdown put the a dot(.) or 127.0.0.1 if the server is sitting on your machine or put the name of your machine

choose SQL authentication....