please....
not databases. There is a limit of 256 catalogs per server in sql 2000. I would like to know if this has been increased in 2005 ? thanks much.
Hello, I hear that there are only 255 databases per instance with full-text enabled on sql 2000. Is the limit upped in 2005 ? I would like to...
Hi, Can u pls explain this a little more in detail ? Should I create OS user (system level) ? we have been using sql level logins so far....
Hello, I have installed msrs in a dev server, and I can hit the reporting page thru http://localhost/reports -- where we can create folders to...
All, for win2k advanced server, with sql2k standard running on it, do I need to run any sql specific pathches for DST change ? Can someone point me...
i meant from 6 dbs to another 6 dbs. It is a 8cpu, 8gbram sql2kEE, win2k adv server.
Unfortunately i cant change the code. I have 12 databases in my server. 6 processes are running. they are selecting rows from 6 databases and...
yes. i had an error : Cannot use Address Windowing Extensions because lock memory privilege was not granted i enabled awe to 1 and did a...
It is a dedicated box, very powerful. 4cpu hyperthreading. awe is enabled and set to 1, but still no change. I also tried, min and max server to...
Hello, My sql server 2k enterprise edition with sp4, running on 8 cpu and 8gb ram, with 7.5gb allocated to sql. But it is only using 1.7gb. The...
Hello, I have 2 databases A & B. We do some ETL on A, and finally insert them to B. B is a data warehousing datamart, with 100s of indexed views....
satya,<br /><br />can you please elaborate on what to check ?<br /><br />Make sure you have full control permissions on the keys<img...
Hello, I have a SAN environment, where sql2k is accessing, and I get lot of PAGEIOLATCH_SH latches. I suspect the disks having issues, at times they...
But I dont see this Management Studio installed, with my installation. I can connect to the instance thru osql now. what do i need to do get these...
Hello, I got the 2005 ent edition(32) from my IT. While trying to install on win2ksp4 box i encountered some issues. I installed MDAC components...
dineshasanka, What is the script/solution you provided? I received a MDF from a client, and trying to restore it to my server. I did NOT have this...
Hello, I have a create_date column which populates system date into it (hh,mi,ss include). One of our reporting system sends query like this:...
DBAs, I have to add a few tables to the existing set of replication tables. I added them in the publisher article. Now what should I do for it to...
http://superspeed.com/servers/ramdisk.php http://superspeed.com/servers/ms-sql-performance.php#1 DB is around 16GB. We have HP ProLiant DL380 G3....
Separate names with a comma.
