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...
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...
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....
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...
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...
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...
Hello, Is anyone using RamDisk for SQL Server and its tempdb ? Will SQL server work fine / supported with ramdisk. I am thinking of this as an...
Hello Directors of Beer Administration (DBAs), I had log shipping working successful for ages. Recently, I had to define transaction replication...
hello, i have a create_date column in my database, which also has hours,minutes and seconds. it has an index on that column as well. while my...
hello, I am trying to create a table thru select..into. I need the same datatype of column A for column B, but with all NULL values inside it. Is...
guys, I would like to know the experience of installing sp4 ? (in production) any hiccups ? or is it recommended or wait & watch ? bj
Hello all, I have sucessfully configured running LS before on many occasions. win2k adv, sp3a Recently, we have some changes and i have got a new...
Hello, I know it is weired. There was a network outage in our data center, which also involved reboots to many machines suddenly. When the dust...
Hello, I need to monitor the #of user Connections for a specific database. Is there a way I can modify the existing...
I have created my LS standby db in a secondary server. But, I have not transferred all my logins. I was accessing the standby db using the 'sa'...
Guys, I have MSSQL 2000 SP3. Today i just found out, i am missing my SQL Server counters in perfmon. Any help, appreciated. bj
Hello, My desktop machine is in domain1, and I have sql servers in domain2. I also have NT login accounts and sql server logins to that domain2...
Separate names with a comma.
