Is there some way to make SQL Server not append white spaces to fields when the data is returned from a select, but still return any white spaces placed in the field by a user?
I have a reindex script that is failing with the error "Msg 1934, Sev 16: DBCC failed because the following SET options have incorrect settings: 'ANSI_NULLS.'. [SQLSTATE 42000]"
I ran SET ANSI_NULLS ON, then ran the reindex script and it failed again with the same error? It doesn't...
I have 2 Windows 2K servers with MS SQL 2000, clustered. Linked server was set up on a stand-alone sql server linking to Node A using the cluster name. Installed MS DTC and added it as a resource in the Cluster Admin on Node A (Node B was down at this point.) When I booted Node B, I received...
I would love to get responses from anyone who is on PeopleTools 8.42.08 (exactly this release) or later and whether or not you feel this release is stable. I'm specifically interested if you are running Microsoft Windows 2000 for any component, i.e. database, application, process scheduler...
I have a W2K Server with SQL Server 2000 SP2 installed. The port number is 1433 (default), but we need to change it. Is it possible to change this port number or do I have to reinstall?
Anyone know of any software or has anyone written anything that will give you a client connectivity count on the application servers? I would really like to see how many concurrent users we have compared to our slow performance times. Thanks in advance.
I am running a crystal report with a cross tab graph. It runs fine on my desktop, but errors on the server with this error "Crystal Reports Print Engine error text: Error detected by database DLL." After running an ODBC trace on the server I see this error "CRW_ELWCC060_17...
Help!! My database ran out of disk space when reindexing in the middle of the night and is now in suspect mode. Once I found out, I deleted some files to release space, but it's been over an hour and it is still in suspect mode. What do I do? Both mdf and ldf were on the same drive.
Microsoft Windows 2000
Microsoft SQL Server 2000 Enterprise
Recovery Method = Full
Production database file = 36,140MB current size, 26,535MB space used
Production log file = 1,322MB current size, 43MB space used
Autoshrink = NO
Backup schedule Monday-Saturday:
Log backups every 4 hours/daily...
I have a small table with 34 rows and 4 columns that I need copied from one server to another. Everytime I perform the copy with data, everything comes over fine except for the 3rd column which brings back 'NULL' in every row?! I don't understand because the content came over for every other...
I started to restore a database, something I've done hundreds of times, but in the middle of the restore I received an error that stated "ConnectionRead (recv()). General network error. Check your network documentation." The file I was restoring from was copied from a different...
Does anyone know the exact steps that are best to take when upgrading from SQL 7.0 to 2000? Do I do an install of 2000, then restore a 7.0 bak file to upgrade? How to upgrade, is there a wizard? What gotchas are there with upgrading? Thanks for the info in advance.
Why doesn't SQL Server 7.0 release memory? I have 2 GB of memory and task manager says that Memory Usage is 1963228KB. There is hardly any activity on my application server, which means hardly anyone is on the server doing anything. Noone is doing anything directly to the database. How do I...
I think we have an in-house hacker in our company. I have a Windows 2000 server that I have gone to Local Security Policy > Local Policies > Audit Policy and turned on Success, Failure to "Audit directory service access, Audit object access, audit system events". I went to a...
I never started SQL Server Profiler and I see entries for it in the Application Log on my server. SQLServerProfiler is listed as the source and "Trace Started, Trace Stopped, Filter Changed, etc." is listed as the Category. Noone in my group has started it either. What is happening...
I installed oracle8i personal edition for win98 and everytime I start the database it ask for a startup password, just password its not asking for userid or login name.
I already tried tiger, manager, change_on_install without success. Does anybody know the password, please help.
I installed oracle8i personal edition for win98 and everytime I start the database it ask for a startup password, just password its not asking for userid or login name.
I already tried tiger, manager, change_on_install without success. Does anybody know the password, please help.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.