Answer Questions

• KaraokeJoe Using Select Into

  Hello, I am trying to use the following statement, ALTER TABLE AuditAbatements ADD SELECT * INTO AuditAbatements FROM Abatements WHERE 1 = 2, but I am getting a syntax error. I am trying to copy the structure of another table into a table that is already created. Can this be done Thanks Thanks for your help! Sorry, forgot to add: And to do this dynamica ...Show All

• Flack how to insert more than once when processing one row in script component

  I am trying use call DirectRowToOutput0 more than once to achieve the goal, but it gives an error of calling COM. I can create more than one destination to achieve it, but I need create 8 destinations for my situation. Is there any easy way Thanks Is this any help to you: http://blogs.conchango.com/jamiethomson/archive/2005/09/05/2113.aspx -Jamie That is it. Thank you so much. In that case this will be an asynchron ...Show All

• wsr429 Unable to connect to SSAS

  On my local machine i'm unable to connect to my ssas. I'm working with a developper license and the service is running. It is working with a default instance, browser is running. I'm able to connect to the database server, ssrs, ssis, .... This is my error... TITLE: Connect to Server ------------------------------ Cannot connect to BI_DEV. ------------------------------ ADDITIONAL INFORMATION: A connection cannot be made. En ...Show All

• nag_ravi AWE enable and SQL Server 2005 x64 bits

  Hello, I am setting up a new server with Windows Server 2003 x64 bits and SQL Server 2005 x64 bits. Under 32 bits of Windows we normally use /3GB and enable AWE under SQL Server (both SQL 2000 and SQL 2005) and allocate 6 GB of fixed memory to SQL Server. Does any one know whether I should do the same thing under the x64 bits platform. I read some articles on the web that it is no longer required to use AWE under SQL 2005 x64 bits Ple ...Show All

• Kristian PD Internal Query Processor Error

  have a few report have the following error when i point the db to the test server. but it was running fine when i point the db to the live server in the same machine. in fact, the live server are having much more records then the test server, but wondering how come the live server do not hit such error, is it due to the SQL server version different appreciate any1 can help. thanks SQL server version in both server In live server the the SQL vers ...Show All

• Lexin Shan Customer Issue Report subfolders

  Within a single project, is there a way to move reports to subfolders without deleting and moving Thanks! BobP Hi Bob, You can create Linked reports from the properties page of the report on the report server. There is a button named create linked report, which creates a copy of the report on the target report folder. After the report has been created you can change parameters, etc and use it. You can implement reports for ...Show All

• AAx sql server agent

  We're using sql server 2000 agent. The jobs running under it run constantly, writing to and reading from the database. Our problem is that some of these jobs stop for no clear reason. Can anyone help Maybe you should add some tracing to the stored procedure so you can see where exactly it is failing. They stop with the following error message:   SQL Server Schedul ...Show All

• singersoll What is the performance difference between using varchar fields of vastly different sizes?

  I was wondering what the performance diffeneces/issues there are between using  varchar fields of largely different sizes ie varchar(100) vs. varchar(5000)  From what I have read SQL Server only stores the actual bytes of the data written to the field, so data 50 bytes long would be stored the same in a field of varchar(100) or varchar(5000). Everywhere I look people say to use the smallest size possible but given few if any reasons fo ...Show All

• Ian K cursor problem

  Actually My proble is DECLARE @SNO INT DECLARE CURS_FOR_SNO CURSOR FOR SELECT * FROM MACB where cntrl_no='DC000429' and isnull(listed,'')='U' AND ISNULL(SNO,'')='' ORDER BY SNO OPEN CURS_FOR_SNO FETCH NEXT FROM CURS_FOR_SNO WHILE @@FETCH_STATUS = 0 BEGIN SET @I=@I + 1 SET @SNO=@X + @I UPDATE MACB SET SNO=@SNO where CURRENT OF CURS_FOR_SNO FETCH NEXT FROM CURS_FOR_SNO END CLOSE CURS_FOR_SNO DEALLOCATE CURS_FOR_SNO it gives read ...Show All

• vighnesha The connection manager 'OLEDB' is not properly installed on this computer

  Please help someone from MSFT! I've just finished installing the Sep CTP on my laptop.  I previously had the April CTP and June CTP.  I followed the instructions for removing a previous installation of SQL 2005. Now, when I try to create an SSIS package, I get a message that says: TITLE: Microsoft Visual Studio ------------------------------ The new connection manager could not be created. ------------------------------ ADDITIONAL IN ...Show All

• Frankie Myat Connecting a web app to sql server

  I have a web application running on Server A and need to connect to a SQL Server database on Server B. In IIS on Server A, I have created a virtual directory called gdoc.  For Directory Security I am using Integrated Windows Authentication.  When I try to access the application, I get the following error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. /gdoc/properties/GDocProperty.asp , line 23 When I change IIS to allow an ...Show All

• DevilFish Grouping a query in 30 seconds

  Hi, How can I make a query and group the registries in a interval of 30 seconds...like for each line I have a datetime field that have all the day, and I need it to return just like TIME Contador_type1 Contador_type2 Total 01-01-2006 00:00:30.000 2 5 7 01-01-2006 00:01:00.000 3 7 10 It's just an example...but that ...Show All

• Brad House Change query issues

  I am trying to take this statement: Select Total = SUM(gt) FROM (Select Distinct CustomerName, CustomerNumber, FeeGoal_AZ AS FG, FeeSchedule, (cast(FeeGoal_AZ as numeric(30,10)) / FeeSchedule) * 100 AS gt from DCR WHERE branch='00002' group by CustomerName, CustomerNumber, FeeGoal_AZ, FeeSchedule ) as dTable and change up (cast(FeeGoal_AZ as numeric(30,10)) / FeeSchedule) * 100 AS ...Show All

• Washu 5 clients takes 5 times more

  Hi there! This is the scenario: I've got a dataset to handle data in aplication tier. I've sent transactional operations to data layer. In data layer I've got stored procedures that handle xml data to "keep" and "retrieve" data in/from database. This is the idea. After some tests I get this code in DB: DECLARE @Documento as xml DECLARE @QtdReg as int DECLARE @Contador as int SET @Contador = 1 ...Show All

• Renynet WMI alerting error

  After installing SQL Server 2005, I tried to create a WMI alert by doing the following: USE [msdb] GO EXEC msdb.dbo.sp_add_alert @name=N'Database Created', @enabled=1, @delay_between_responses=0, @include_event_description_in=0, @wmi_namespace=N'\\.\root\Microsoft\SqlServer\ServerEvents\MSSQLSERVER', @wmi_query=N'SELECT * FROM CREATE_DATABASE', @job_id=N'00000000-0000-0000-0000-000000000000' GO This p ...Show All