| Thread | Last Post | Replies |
|
| Backup from SQL Server 2005 - restore to 2000 | 11 Mar 2008 12:53 GMT | 6 |
I need to restore a backup of a db in SQL 2005 with 80-compatibility level into SQL Server 2000. I have tried to do it but I have an error. Is it possible to do it? Does exist another fast method to bring a SQL Server 2005 db into 2000?
|
| Finding Sql Server Licensing information | 11 Mar 2008 11:47 GMT | 1 |
I want to retrive the licensing information such as Licensing count, which licensing is currently in use, whats its type (per processer or per user), licensing code etc. From where i can retrive the information? I want to do it for Sql Server 2005 and 2000. I read the blog ...
|
| xp_cmdshell runs randomly | 11 Mar 2008 11:40 GMT | 2 |
I have a problem with the xp_cmdshell stored procedure on SQL Server 2005. I've allowed its execution on the databases which require it, using the sp_configure 'show advanced options' and sp_configure
|
| Determine if MSDE or SQL Express is installed? | 11 Mar 2008 09:50 GMT | 1 |
Is there a best practice in determining whether MSDE installed on a workstation or if SQL Express is installed? The SQL Express installs are all with the default named instance of .\SQLExpress, but it's not otherwise generally known as to which version is present.
|
| Close to real time sync for data in relational and flat schemas | 10 Mar 2008 23:22 GMT | 4 |
Can someone point me to the right direction? I need to synchronize data updates in relational schema with data in it's flat (denormalized) equivalent in near real time mode. What is the best way to achieve this if using triggers is not an option ?
|
| Can't import Access tables..? | 10 Mar 2008 22:27 GMT | 1 |
When I use the import Wizard in SQL-2005 I get the following message: TITLE: SQL Server Import and Export Wizard ------------------------------ Error 0xc002f210: Preparation SQL Task: Executing the query "" failed
|
| Updating Statistics | 10 Mar 2008 21:33 GMT | 3 |
I have a database which has logical fragmentation in some of the tables. I have scripts that now will run an update_statisitics with fullscan on all the objects. I also have a job that perfroms a dbcc dbreindex on the indexes if the
|
| Which SP2 for SQL Server do I install | 10 Mar 2008 21:20 GMT | 1 |
I have an x86 version of SQL Server 2005 installed on an x64 Windows Server box. Which SQL Server SP2 do I install? The x86 one or the x64 one?
|
| database size and raid configuration | 10 Mar 2008 21:07 GMT | 4 |
Hi I need to provide following information: 1. Size of all the current databases on all sql server (2000 and 2005). Is these a query I can use to get this information.
|
| difference in file size on disk and sysaltfiles | 10 Mar 2008 21:01 GMT | 4 |
SQL server 2000 When i select size of files using sql server using "select name,filename,size from sysaltfiles" I get size of files as File one size: file1.mdf = 4976
|
| Testing Phase - Migration from SQL 7 to SQL 2000 - Queries are slo | 10 Mar 2008 20:30 GMT | 1 |
We are using 2 CPUs which are quad core. We have one SQL 2000 License with 1CPU license. The queries are slow when upgraded to SQL 2000, We thought of upgrading to 2 CPU license, Before buying we increased the SQL Proccessor usage to two the
|
| nText and RTF format | 10 Mar 2008 17:31 GMT | 1 |
we have a field under nText which contains both text and RTF text!(database design and app are by another company, no way to modify them) simple select query returns normal values under text data, but when it is RTF we get unnecessary info such as:
|
| Weekly maintenance plan hogging system resources | 10 Mar 2008 17:23 GMT | 12 |
Our weekly maintenance plan takes up so much RAM on our Windows Server 2003 with service pack 2 (2 GB of RAM) that we have to reboot the server the next day in order to free up the RAM. Besides adding more RAM, is there anything else that can be done to
|
| Need help with SQL Select Count statement | 10 Mar 2008 12:58 GMT | 3 |
I want to pull records from a "Column" within a "Table". I recall in the past doing a: SELECT COUNT "n" FROM .... (This is where I am lost!). I am hoping to pull the contents of the column in a table.
|
| Security context? | 10 Mar 2008 12:53 GMT | 2 |
SQL Server 2005 sp2 Windows Server 2003 I have a scheduled stored proc that executes Bulk Insert. It works fine. Agent runs under a domain, sys admin account. I know, I know,
|