How do i know what the server name is? On my computer i used my first name. It appears when i open Query Analyzer within the Connect to SQL Server...
This article was the most helpful. http://support.microsoft.com/kb/224071/ I deleted the db on the destination computer. From what i read on BOL,...
If i detach a db file on the original will i still be able to use the original or must i attach it again to use it on the original machine?
I found this article that seems to address the subject but i'm trying to understand it though. http://support.microsoft.com/kb/314546/
I think it would be better to "detach/attach database from SQL server and move to other server" If i imported from Access, i would have to do a lot...
I have info on my desktop computer i need to move to another computer. But my computers are not networked. If i use Access, I can just save the file...
I'm using SQL Server2000. Up until now I've been testing my database connection on my workstation. How do i modify my connection string to reach a...
Thanks very much!!!!!!!!!
One other question. The only problem is that it will allow nulls in the EmployeeTests.SupervisorID column when no Supervisor is needed to take the...
Thanks guys! Mmarovic, thanks for the detailed explanation. That is exactly what i needed to know. I didn't understand your country analogy...
my current DB Schema can be found at http://www.geocities.com/jacobpressures/index.html If it is hard to read you might be able to download it and...
sorry. Ok, I got my application role created. After discovering there are characters who can and can't use in the encrypted password got the...
Yes, i will probably use triggers for cascade deletes because all my relationships in my DB are basically circular. So using DRI will not work for...
Thanks very much. This is probably the most beneficial info I've recieved. Everything i've read has told me something about indexes and i understand...
Thanks, merrillaldrich! Should i set the clustered indexes before i use the Index Tuning Wizard or afterwards? Thanks again!
Thanks! I'm using triggers to enforce business rules.
I've tried getting clustering advice to no avail. Everyone always tell me that there is no way of telling which columns should be clustered because...
I'm a newbie and trying to figure out the best way to do things. What i learn i will probably stick with so... Should i create only one trigger for...
Thanks very much. I was able to find some information on BOL. I still have trouble using it. Basically nchar and nvarchar is to support languages...
Another stupid Newbie question. What is the difference between varchar and nvarchar? char and nchar? why buy books when no one explains it....
Separate names with a comma.
