Search results for query: *

Via SQL Enterprise, I am trying to created a local server group (local) when I trying to do it I get an error message that cannot authenticate using windows or SQl authientication. I am not able to add local server... Any help would be really appreciate.. Regards, James

I have the following query that pulls a TermID Publication source. I am not getting any results, I get the Term ID but Publication source NULL. Please any suggestions. Thanks very much in advance. SELECT gps.TermID, gps.PubSourceID, gpsr.PubSource, FormattedPubSource=CASE WHEN...

I am trying to skrink the log files for a database logical name GPSDYNAMICSLog.ldf, I want to have 2 MB size, and I do the following. When I use DBCC SHRINKFILE (GPSDYNAMICSLog, 2) I get the following: Server: Msg 8985, Level 16, State 1, Line 1 Could not locate file 'GPSDYNAMICSLog' in...

I am new with the company and I am trying to detail every piece of the configuration of our SQL server 2000. Would you please assist me identifying the best process to do this. Can I run a Query Analyzer. Thanks Jimmy

So using shutdown.exe will reboot the server, I cannot manually restart the server, I am schedule the server to reboot at 11:00 PM. Thank for yourhelp Sincerly, Jimmy

I need to schedule our SQL Server to reboot every night according to our vendor. I am trying to setup a schedule task without success. I cannot find reboot.exe. Would someone tell me where can I find it or a way to write one. Thanks for all your assistance in advance. Sincerely, Jimmy

I am creating a full back up to run every night from my SQL Server 2000 to an IT Server backup SQL. I have mapped my IT drive to the SQL Server 2000 with no issues, but when I am trying to create the backup using enterprise manager, and add the drive I cannot not see the drive, is not one of my...

I need an advise, I was recommended as part of the maintenance plan to schedule the SQL Server 2000 to reboot every night, (shoutdown and restart) this will provide me with better preformance. Please what would be the best way for my the server performance. Thanks in advance. Regards, James

I am getting the following error message , would anyone experience this before. Thanks in advance. THe L drive is my SAN I/O error 21(The device is not ready.) detected during read at offset 0x0000000006e000 in file 'L:\MSSQL\Data\WEBIMIS_Data.mdf'. Connection Broken

I have 4 different reports that use the same SQL tables Links. I have a problem when I try to make changes to the report 1 and is a user in report 2 I get a message saying "I need exclusive access to make those changes" The report are not even connected share the same table but nothing else...

I am moving to a new SQL server. I have 10 workstations. I have alreary migrate the Dynamics to the new SQL server. HOw can I point the 10 workstation to the new SQL server. Thanks in advance for your assistance. Jimmy

I have about 15 databases on SQL server 1 including production, testing and development. The data files are going to the SAN (J) and log files are going to (K. for example j:\mssql\datafiles\ -- 15 databfiles reside here -- k:\ log files L:\ all my back up - Like you can see all my files...

Good Morning May I please have an assistance. I have worked on the query below but the query is creating very issues mainly in performance very costly. WOuld please take a look and see if would be a better way to write it. Thanks in advance. The query is set up to limit access to certain...

I currently running SQL server 2000, sp3a, dual processor Intel 3.4 Gig each. The SQL server is dragging and its running 100% CPU, 150 GIG hard drive. We have about 10 small databases running on the box totalling about 15 GIG. I found the the temp.db file is getting very large, even thought I...

I have a database that processes all my online transaction. Startind yesterday the database is growing extremly large, slowing the website and up to the point the when members trying to login to the website it doesn't authenticated. I have shrinked the database log files, then everything goes...

I need to install SQL Server 2000 on 3 desktops, Currently I have 2 CDs, personal edition and Standard edition. which o the 2 I should use. Appreciate all the assistance and the advise.. Regards, Jimmy

I was told if I am using Reading Pane to view my email I am activating any email viruses that may recived. I like to confirm that the information is correct. Unless I open the attachement and activate the .exe I will get a virus, but not by using Reading Pane. I am trying to find information my...

I am going out of town and I am trying to take a local copy of the SQL databases, when I am trying to create a new SQL registration (local) or (IT-201) "which is my local machine", I do not have the option. When I type the name and authenticate using windows just hangs.. How can I create a...

I am currently using SQL server 2000, but I am trying to install SQL Server 2005 using virtual pc for testing. please does anyone can tell me how can I install SQL server 2005 in a virtual pc. Thanks for your valuable help. Regards, Jimmy