| Thread | Last Post | Replies |
|
| Query Analyzer Slow - Management Studio Fast | 01 Apr 2008 00:28 GMT | 4 |
If I run a simple "select top 10000 * from table" query against a SQL 2005 server from a client pc using management studio the query returns in about a second. Running the same query on the same client pc using the older query analyzer takes 25 seconds.
|
| capture udf calls in trace | 31 Mar 2008 20:00 GMT | 2 |
I know is possible I just forgot how. Thanks.
|
| LOG files | 31 Mar 2008 19:35 GMT | 1 |
I moved all my data files from mssql2000 to mssql2005. problem is that my log files are GB's bigger than the MDF file. Can I delete the LOG files? IF not, can I reduced the size? How?
|
| I/O error (torn page) detected during read | 31 Mar 2008 18:37 GMT | 3 |
we are running a maintainance plan on sql 2000 standard edition, got the error, [2] Database db_source: Check Data Linkage... [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 8928: [Microsoft][ODBC SQL Server Driver][SQL Server]Object ID 1221579390, index ID 0: Page (1:197116)
|
| How to copy a Sql Server Database | 31 Mar 2008 17:00 GMT | 2 |
Hi, how can I copy the schema and the content of tables from one database to another ? Thank you Andrea
|
| SQL 2000 object name | 31 Mar 2008 16:30 GMT | 1 |
I am looking for an object in a SQL 2000 db. I tried using fn_listextendedproperty but having no luck. How do I look up say an object called 'ABC' in a complete db thanks in advance
|
| ss 2005 cluster install issue | 31 Mar 2008 16:17 GMT | 5 |
I have installed sql server 2005 clusters before, but never ran into this issue When I get to the screen to pick a drive for data files, after selecting any of the available ones I get the same error "there is not enough disk space on the destination disk for the current sql
|
| Is there a Cluster command line I can run which will stop my "SQL Agent Service"? | 31 Mar 2008 15:23 GMT | 5 |
Gurus, Running SQL Server 2005 SP2 on a Windows Server 2003 Cluster. Is there a Cluster command line I can run which will stop my "SQL Agent Service"? --
|
| Windows Integrated Security Error with SAC | 31 Mar 2008 14:38 GMT | 3 |
I am unable to connect to SSRS (for managing reports, etc.) within SSMS (it throws out a HTTP 401 error). So, I thought the configuration may have been set up wrong or something so I opened up the SQL Surface Area Configuration tool. The RS service was running and when I went to ...
|
| Query a Table to return Non-Date values | 31 Mar 2008 13:51 GMT | 3 |
I have a table with dates stored in a nvarchar(75), I would like to move this over to datetime (for obvious reasons) the problem is the field has some 'bad data' how can i query the nvarchar field to return me anything that isnt a date?
|
| The log file for database 'temdb' is full | 31 Mar 2008 12:50 GMT | 1 |
Server generated an error 9002, Severity:17, State 6 The log file for database 'temdb' is full. Back up the transaction log for the database to free up some log space. tempdb.mdf file located at D:\Microsoft SQL Server\MSSQL\Data\ is with size
|
| SQL Server does not allow remote connections | 31 Mar 2008 09:54 GMT | 8 |
Using google I find that this is probably the most posted problem on the internet. The answer is always "check the box to allow connections." This problem started on my workgroup a year ago when I went to sql server 2005 and to get around it I just started installing sql server ...
|
| SQL 2005: SSMS Toolbar Customization--Import/Export Wiz | 31 Mar 2008 08:42 GMT | 1 |
If I add the SSIS Import and Export Wizard to a toolbar (Tools > Customize... > Categories:Project > Commands:SSIS Import and Export Wizard...) in SSMS, it is disabled (dimmed/grayed out), at least it is when I have nothing else open and I'm in Object Explorer Details inside a ...
|
| PROFILER | 31 Mar 2008 06:17 GMT | 1 |
What would be the best place to run profiler, on the production Server or on another client Machine? Thanks,
|
| Restore database | 31 Mar 2008 04:10 GMT | 1 |
I have 4 files sent to me by a client, LogData.bak, PioneerTables.bak, SEF.bak, and WSD.bak. I want to restore the database in SQL Server 2005 Express. I select Databases and right-click and select restore database. There is no database in the To database drop down and typing
|