Search results for query: *

Short answer: Use bitmap(.BMP) wallpaper only in group policy. Long answer: Thought I would save someone else a big headache. I just finished a domain controller/file server migration from win 2000 to win 2003 Server. In the process it was necessary to change the URI paths of the server...

Maybe it is the one. Fortunately, XP doesn' sc**w up the user profiles when rejoining to the domain. W2000 is a bit more complicated. One important clue to the problem is that it began while you were on holiday. Everything was working properly when you left and broke while you were gone. Give...

- Make sure that all machines are configured for domain and not workgroup access. - Also make sure that all win98 machines are using Windows Client set up for domain access and using Windows file and print to share files. - Make sure that "browse master" is disabled in file sharing on all...

It may be better to have a table containing cities with 3 columns: City_ID, CityName, CityCode eg 44, Los Angeles, LA etc. City_id should be a primary key or constrained to be unique then you could write: INSERT INTO TABLE_XYX SELECT T.CustomerNo, isnull(C.CityName,'other')...

Another reason for "access denied" or "permission denied" occurs when you attempt to manipulate, i.e. overwrite or delete, files that are opened by another process. Is there another process running that accesses one of the files, causing a file sharing lock? If you are executing programs or...

The name of the database violates rules for identifier names which must begin with an alphabetic character or underscore. It is being mistaken for the number 2003. Two choices: - rename your database (may not be advisable unless you are in the process of designing it) - use double quotation...

Correct the offending line as follows: -- ** Error seems to be caused by the where clause ** Select * from @TableVar TV, t_orderitems WHERE TV.idfield = t_orderitems.idfield also remove the 'as' from the table declaration, that seems to fail for me: declare @TableVar table (idfield...

I found the same code as above on the microsoft site at http://support.microsoft.com/default.aspx?scid=kb;en-us;Q312839&sd=tech#3 although now the article seems to be missing without a trace from their servers. Maybe this threatens the sales of MS Exchange? I enhanced the error handling by...

As Dan1967 noted, chaining procedures causes each procedure to remain pending in memory until the last ends. For this reason it is rarely a good idea. I have seen people cause system crashes by having the last call the first to implement a loop. Consider SQLSisters response, and if you need to...