Every once and awhile I'll see this message popup in the Event View on my sql server box. Could not get performance counter registry info for...
So I'm preparing an update script to run on existing sql databases. In my script I want to create a schema if one does not exist and not create if...
Based on the responses I'm getting there is a bit of confusion here. My application is a desktop application that connection to a local instance of...
No I do not stop the sql service first. I simply go to to Start Menu -> Re-Start I've never stopped the sql server before when either shutting down...
A few of my users are having a strange problem with there SQL Express install. After a reboot of the machine, the initial attempt to communicate to a...
I've spent much time researching this issue and know that it's releated to a corrupted log file. At the end of last year I had several users who had...
Is there a way to regulate System Resources on a machine that I have SQL Express 2005 installed. Limit the size of the database or memory usage?...
Thanks for the reply this has been highly educational. The frustrating part is that with SQL 2000 I never experienced this issue where I fine tuned...
techbabu303: By trace do you mean SQL Profiler? satya: Thanks for the links I will look into them. Yes this database was upgraded from SQL 2000...
Hopefully this is the correct forum to post this in... We have 3 environments dev, test/stagging and production. Our dev group worked on database...
I have an MDF and LDF file that I have been unable to attach to a SQL 2005 server. When I attempt the "Attach" process I recieve the following...
Is there a way to restore a database backup file to the default data directory in a specific SQL 2005 instance using T-SQL? I know that you can use...
Thanks Satya that worked after I added the privilege.
I am currently having a problem with restoring a backup made on SQL 2000 XP machine onto a Windows server 2003 machine with SQL Express 2005. I am...
Thanks Chappy that worked like a charm...
Chappy thanks for the suggestion but that is only true if the employeetraining class is prepopulated with enteries and all I need to do is update the...
I have select statement that I am having a hard time trying to create and hopefully someone will be abel to shed some light. I have the following 3...
After discussing with my other collegues we have come up with a solution.....
I need help in determining if there is a way to disconnect user from a specific database. I have an application that performs a couple of exclusive...
Thanks for the all the replys I'll look into the isnumeric function.
Separate names with a comma.
