Viewing 15 posts - 33,136 through 33,150 (of 39,740 total)
I might also try rebuilding the clustered index and seeing if you can rebuild the structure of the table.
April 12, 2006 at 8:53 am
You cannot have multiple primary keys on a table. You can have multiple indexes, even unique indexes, but only one primary key.
They could be compound keys.
April 12, 2006 at 8:51 am
Frank,
Excellent points and I may have to pick up an old Zaurus and see if I can get RDP running under Linux ![]()
April 11, 2006 at 2:55 pm
Thanks for the kind words from all three of us.
Steve
April 10, 2006 at 10:01 am
Good points. However, we did lots of work with 486-66's and previous. There were many tasks that we could complete. It's as we evolved that we have built so much...
April 10, 2006 at 9:57 am
Service packs are not listed anywhere. You go off the build version and compare it to http://vyaskn.tripod.com/sqlsps.htm
April 10, 2006 at 6:55 am
Interesting solutions and thanks. I said 1 myself, but both are interesting solutions.
I also think that the requirements, asking to read the table once, are misleading. I don't think that...
April 7, 2006 at 5:19 pm
Jan,
There is no easy way to do this. Something needs to connect to both servers and compare the data. You could send your master db to the customers and run...
April 7, 2006 at 8:58 am
Also you will need to configure outlook using the account that runs SQL Server.
April 7, 2006 at 8:53 am
Really you'd need to track your database size on a daily or weekly period and then use that. Error logs work as well, but if you are having regular growths,...
April 7, 2006 at 8:51 am
Post moved.
Prakesh, what are you trying to do? You can "close" the database with autoclose and resources will be released, but if someone accesses the database, it will reopen. This...
April 7, 2006 at 8:50 am
I agree with the above. I started in 91 with the old syntax and never had issues. Outer joins were tricky, but they're still tricky.
However I swithed to ANSI syntax...
April 6, 2006 at 5:48 pm
You might scan the scripts on this site for some VB Script items. The ones I've most often used are the FileSystemObject and basic server connections (recordset, connection objects).
Here are...
April 6, 2006 at 5:07 pm
Normal is relative to your server. What might hang your server works great on mine.
You need to look at a bigger picture and not worry about that counter. Find out...
April 6, 2006 at 5:00 pm
SQL Server is ODBC/OLEDB compliant. Your web server would communicate with SQL Server using one of these types of drivers. There are not specific ones for each applicaiton.
April 6, 2006 at 12:27 pm
Viewing 15 posts - 33,136 through 33,150 (of 39,740 total)