Answer Questions

• Mark Coleman SQLWB.EXE max cpu

  SQL Server Management Studio 2005 Windows 2000 when I "Open Table" to view all the records in a table, the cpu goes to 100% and the records are drawn very slowly - about the same speed as you read ! I have re-installed all the software and also tried service pack 1. SQL 2000 worked fine. any ideas thanks John, UK Microsoft SQL Server Management Studio 9.00.2040.00 Microsoft Analysis Services Client Tools 2005.090.2040.00 Microsoft Data Access Components (MDAC) 2000.085.1117.00 built by: (_sqlbld) Microsoft MSXML 2.6 3.0 5.0 6.0 Microsoft Internet Explorer 6.0.2800.1106 Microsoft .NET Framework 2.0.50727.42 Operating System ...Show All

• Carl Daniel SQL 2005 compatibility

  Hi, i'm using a query to insert a value in a field named 'From' in a table. i used like Insert in to myTable ([from]) values('01/01/2005') The query was working in sql 2000. but in sql 2005, i'm getting a error like 'Syntax error near 'From'. what could be the reason for this Try like this, USE MSDN CREATE TABLE [tblTemp1] ( [ItemID] [int] NOT NULL CONSTRAINT [DF_tblTemp1_ItemID] DEFAULT (0), [ItemUserDate] [smalldatetime] NOT NULL CONSTRAINT [DF_tblTemp1_ItemUserDate] DEFAULT (getdate()) ) ON [PRIMARY] GO INSERT INTO dbo.tblTemp1 SELECT * FROM dbo.tblTemp1 SELECT * FROM dbo.tblTemp1 Could you please post a simple repro script that dem ...Show All

• old mpipe Linked Server Problem SQL Server 2005 to SQL Server 2000

  I've been trying to add a linked server om my SQL Server 2005 Beta 2 install. The Linked Server i'm trying to add is a MS SQL Server 2000 with Service Pack 4 installed on it. The code i've run on the SQL Server 2005 server to add the linked server is the following: EXEC sp_addlinkedserver @server = N 'JANET01' , @srvproduct = N '' , @provider = N 'SQLNCLI' , @datasrc = N 'SERVER=192.168.100.150;Integrated Security=True' The Error i'm getting is the following: OLE DB provider "SQLNCLI" for linked server "JANET01" returned message "Login timeout expired". OLE DB provider "SQLNCLI" for linked server "JANET01" returned message "Client unable to establish connection". Msg 126, Level 16, State 1, Line 0 VIA Provider: The ...Show All

• creaturita .NET Runtime Optimization error on SQL Server 2005

  I posted this on the .NET Framework inside Sql Server forum as well.  Sorry if the cross-post offends anybody. I upgraded my primary production server this morning to SQL 2005.  Everything went fairly smoothly, but a couple of hours after my installation was complete, I found the following error in my event log:   Source: .NET Runtime Optimization Service EventID: 1101 .NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002   I am a little stumped since we did not install Reporting Services.  We only installed Database Serv ...Show All

• Thomo database mail isn't working in the SQL Agent job notification

  Hi, Starting a few weeks ago I stopped receiving notifications when SQL Server Agent Jobs failed. The only error I see from the Error logs is the following: "[ 264] An attempt was made to send an email when no email session has been established " I've followed all of the postings about stoping and restarting the Agent service, confirming that the database mail can send out test emails and making sure that database mail account name matches the actual SMTP account. From my testing, I can successfully send out a test email by right-clicking on "Database Mail" - "Send Test E-Mail." Here's my setup: Active/Passive SQL Server 2005 Cluster. 32 bit SS2005 SP1 installed Database Mail worked for around ...Show All

• BrunoAMSilva sql compact edition and methods

  i had read information about sce and i had not unsderstood a little thing: is it possible or not to use a dataset with that version of sql server i have a class that access the database with some functions and one of then return a dataset. the dataset is not to be used because it does not make sense with sql server compact edition or it cannot by use at all cause sql server compact edition does not support it thkx and by the way i think that it's a great product! Yes, you can use dataset with SQL CE, but on devices it is not always the right solution, due to resource constraints. For a good tutorial see this article: http://msdn2.microsoft.com/en-us/library/bb219484.aspx ...Show All

• Cándido Reporting Services Export to Excel - Without the Colors

  I am using Report Manager as my report interface. I am exporting Reporting Services reports with multiple colors to MS Excel (which has a very limited color palate). When I export the reports to Excel, the system chooses the colors automatically, and I am not very happy with the colors selected. I would like to either control the colors in the export or make the exports black and white. Does anyone have an idea how to do this You don't have control over colors. The only options you can control are enumerated here . ...Show All

• DanScan Newbie to SQL - Which express do I download?

  I am familiar with Access and I write a lot of asp queries connected to an Access db. I am now working with a full blown SQL Server db. I have accessed the tables using Express Management Tools, but now I want to know if I can create a report or export data form a SQL table into Excel like I can from Access. I am currently using SQL Server Management Studio Express. I see there are other options to install, will any of these give me the tools I need to export Thanks Dave "I want to know if I can create a report or export data form a SQL table into Excel like I can from Access" Report with Express Edition, YES. Export to Excel with Express Edition, not via Mgmt Studio Express (Integ ...Show All

• Duque Vieira how can Unzip file text file using SSIS

  Hi, I am pulling text files in gzip format from UNIX system. I want to unzip these files and then import data from these files into database using SSIS. In our environment, we are not allowed to load 3rd party software to unzip a file. However, we did create a VB Script file that accepts an argument for filename and a second argument for destination directory. We use CopyHere to accomplish the task letting WScript handle execution. This involves keeping a vbs file on the server. However, we would ideally like to use the CopyHere (or some similar command) from within SSIS. Any suggestions Thanks I had to opt for the jave code because our client does not have any third ...Show All

• The_Nod Reporting Maneger Failed

  Hi When I try to run de ReportManeger in the internet explorer, Show an error: The report server is not responding. Verify that the report server is running and can be accessed from this computer. Well, I check and te Report server is running. When I try to run de ReportServer in the internet explorer, Show an error: The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) Access to the path 'c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\RSReportServer.config' is denied. Also when I try to use de Surface Area Configuration for Features, Windows Integrate Security, this errror is showing TITLE: Su ...Show All

• R.Tutus Report Server First Time Configuration: Provider Load Failure

  I'm trying to do the above using the Reporting Services Configuration Manager and I can't even connect. I get the error Provider Load Failure. Anyone got any pointers You're using Express Well I figured out my problem, the System PATH variable was missing C:\windows\system32\wbem I added it and rebooted and it works properly. It looks like reportingserviceswmi.dll depends on framedyn.dll which is located in the above path. Moving to RS forum. Mike Well, there isn't much more to say - make sure %WINDIR%\system32\WBEM is in your PATH. If it is not, the WMI provider library (which depends on FRAMEDYN.DLL) cannot be loaded. (the alternative would ...Show All

• Mark Goldstein SQL Mobile for Palm OS?

  I am going to buy a PDA but I don't know which one. I need to use SQL Server CE. Can I use this with a palm operating system Does it have to be windows mobile If so, what version of windows mobile Thanks so much i am having the same promble.... Yes, it has to be Windows Mobile device, Palm OS is not supported by SQL CE. You can get Windows Mobile 5.0 or Windows Mobile 2003 Pocket PC device. Last one is obsolete and not recommended, but it is supported by SQL CE. If you prefer devices made by Palm, you can get Treo 700w/700wx/750, they all run Windows Mobile 5.0 for Pocket PC. ...Show All

• uanmi Kick all Users?

  Is there a T-SQL command to kick all users out of a database while I run an update One other thing, and this is probably  a network issue, is there any way to pass a  message to the users prior to kicking them out, so they can complete what they were doing Thanks Melt NET SEND may not be the best & reliable way to do this type of notification. For one, the Windows Messenger service is typically disabled for security reasons on most OS versions. There have been several security vulnerabilities with this service in the past. So you may want to check the latest news on it since NET SEND uses that service. And the state of the service will change from OS version to another and even servic ...Show All

• mohasad How to nightly copy 1 database to another

  I know this is probably an easy thing to do but I've been struggling with this on and off for the past month or so. All I want to do is copy two databases (our app db's) to two other databases (for app testing and training) on the same server every night. The databases aren't used during this time so they can be taken down if necessary. I've tried using the Copy Database wizard and scheduling the resulting job but that isn't working... Thanks in advance for any direction/help! Of course, the whole 'logical_data_file_name' should be their respective db names... Can you give us more information on how its not working Are there any error messages Thank you all for ...Show All

• Andreia M Crosstab, Pivot Query representation

  Hello, I need help with data representation. I have a query : SELECT USERLOGIN , SOURCE , DBUSERNAME FROM TBL_USER WHERE USERLOGIN LIKE 'Don Crilly' The above query returns the following results: USERLOGIN SOURCE DBUSERNAME ------------------------------------------------------------------------------ Don Crilly FC8 Don Crilly Don Crilly ACT Donald Crilly Don Crilly SFS Don Crilly I need the output in following format: USERLOGIN ACT FC8 SFS ---------------------------------------------------------------------------------------- Don Crilly Donald Crilly Don Crilly Don Crilly Can you ...Show All