Drop database on a different SQL Server.

Transact-SQL

Index ‹ SQL Server

- Previous
  - 1
    - Reporting Services Configuring Default Error Messages There has got to be a way to modify the underlying message returned from SOAP, modifying something in the reporting database messages, or modify some type of htm file. The error page is being rendered somehow. I am going to edit this post and supply a URL to give you an example of what I found. However, this only discusses about doing something and not how to do it. Again, this discusses adding an icon and what I want to modify is the text. http://www.ssw.com.au/ssw/Standards/BetterSoftwareSuggestions/ReportingServices.aspx#IISService Search for Item # 61 "Make this error more friendly by making it visually consistent with the SQL Server Configuration Manager" Tag: Drop database on a different SQL Server.
  - 2
    - need to changes the default port address of apache server can any one guide me how to change the default port address of apache which is 80 to any other port number. coz the default port number is taken by iis also. Tag: Drop database on a different SQL Server.
  - 3
    - selecting top 20 and the rest Anand, Try a select into with the big processing sql and then a union select. Sort of like this: Select * into [temptable] from ( select Id, amount from ({ really big and long time consuming sql statement}) as temp select top 5 cast( id as varchar 255) as [ID], amount from [temptable] order by amount desc union select 'Rest' as [ID], (select sum(amount) from [temptable]) - (select sum(amount) from [temptable] where id in (select top 5 id from [temptable] order by amount desc) Tag: Drop database on a different SQL Server.
  - 4
    - how can I substract a SUM from a SUM? OK then, how about this Chris SELECT SUM ( CASE WHEN visit_items . item_code = 'DISCOUNT' THEN visit_items . item_price ELSE 0 END ), SUM ( CASE WHEN visit_items . item_code ! = 'DISCOUNT' THEN visit_items . item_price ELSE 0 END ) FROM visit_items INNER JOIN visits ON visit_items . visit_id = visits . visit_id WHERE ( visits . visit_is_open = 'Y' ) AND ( visits . visit_file_no = @file_no ) Tag: Drop database on a different SQL Server.
  - 5
    - Problem in Installing SQL Server 2000 Personal No Deepak... we all make mistake... we all are there for a common cause to its help each other and there by improve our knowledge... so pse do not take it as personal... Madhu Tag: Drop database on a different SQL Server.
  - 6
    - Deployment problem Help Hello all experts, I have tried to deploy my cube using an XML Script in dev box, modify connecting string by changing server name, run in QA box, and process cube, but always failed. Error massage: боProcess failed. Trace information is still being transferred. If you do not want to wait for all of the information to arrive press Stop.бп Any one had experience for this error Thanks in advance. Tag: Drop database on a different SQL Server.
  - 7
    - Reporting Services printer problem I have a windows NT service, which prints to a laser printer programmatically using MSRS 2K. It works fine with a HP printer however when I try printing to a Lexmark Printer it does not always print. Somebody help. Microsoft please release a latest patch for MSRS 2K, its been so long since we had one. Tag: Drop database on a different SQL Server.
  - 8
    - Month/Year comparison against a date Hi, Is there a way to get the last day of a month, given a date in a datetime variable I have a stored procedure that accepts a datetime parameter. I need to find the last day of the month for that parameter value. For example, if the stored procedure is passed the datetime value, '6/13/2007', I need to be able to get from that '6/30/2007.' Here's the bigger picture: The sp actually takes two datetime parameters (unfortunately, I don't have access to change the user interface). The sp needs to select records between the month/years of those dates, not including the first but including the second. For example, if the user specifies the following dates: 6/7/2006 7/15/2007 the sp needs to select all records that come after 6/30/2006 and on or before 7/31/2007. I've tried this: ("ReportDate" is the name of the datetime field in a table in the sp and "@StartDate" and "@EndDate" are the datetime parameters in the sp) Month(ReportDate) > Month(@StartDate) And Year(ReportDate) >= Year(@StartDate) And Month(ReportDate) <= Month(@EndDate) And Year(ReportDate) <= Year(@EndDate) But this returns fewer records than when I enter 6/30/2006 and 7/31/2007 as the parameters and just compare dates like this: ReportDate > @StartDate And ReportDate <= @EndDate Thank you. Tag: Drop database on a different SQL Server.
  - 9
    - VB6 RDO error Could you try adding qryStoredProc.Prepared = True Just before using the parameters Tag: Drop database on a different SQL Server.
  - 10
    - Transaction Question When I run the following in Query Analyzer: SET QUOTED_IDENTIFIER OFF -- allows double quotes (") used as wrapper for dynamic sql. DECLARE @E int BEGIN TRAN T1 PRINT 'Start...' EXEC ( " begin tran T2| raiserror( ' inside proc', 16, 11) PRINT STR(@@ERROR) rollback tran T2 PRINT STR(@@ERROR) return " ) SET @E = @@ERROR IF @E <> 0 BEGIN PRINT 'Error ' + LTRIM ( STR ( @E )) + ' out of here...' ROLLBACK TRAN T1 RETURN END PRINT 'Done.' COMMIT TRAN T1 I get the following output and error: Start... Msg 50000, Level 16, State 11, Line 3 inside proc 50000 Msg 6401, Level 16, State 1, Line 5 Cannot roll back T2. No transaction or savepoint of that name was found. 6401 Msg 266, Level 16, State 2, Line 7 Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 2. Error 266 out of here... Anyone have an idea why I would get the 6401 and 266 error JD Waleska, GA MSBassSingerNO-SPAM@alltel.NO-SPAMnet (just remove the string NO-SPAM) Tag: Drop database on a different SQL Server.
  - 11
    - Unable to install SQL Server CE Server Tool on SQL Server 2000 SP 4 Hi, I have installed " SQL Server 2000 SP 4" to SQL server and it is running fine. But when i install the " SQL Server CE version 2.0 Update for use with IIS and SQL Server 2000 SP4 ", i get below error: "SQL Server CE Tool is compatible only with SQL Server 2000 Service pack 1 and higher. When you install SQL Server CE Server Tools on a computer running both IIS and SQL Server 2000 , ensure the installer for SQL Server CE Server Tools corresponds To the version of SQL Server 2000." I have go thougth few articles in the forum, try to open the sqlce20sql2ksp4.exe file and then run only the MSI, but still fail. By the way, i found that the sqlce20sql2ksp4.exe does not include any MSI, it is a direct executable file. Appreciate if anyone tell me the solution. Thanks in advance. Best regards, Plane. Tag: Drop database on a different SQL Server.
  - 12
    - Integrating SSRS with report viewer I'm Sorry Scott still I did not get it..I'm lil bit confused with words. How do I add reporting web serivce reference can I use ASP.NET configuration Where can I find ListChildren mothed & GetReportLink monthed How do I pass link to reportviewer just clicking the smart tag and specifying the report path Thanks Tag: Drop database on a different SQL Server.
  - 13
    - successful implementation of dataware house and data mining hi all i want an article on a company or organization that has successfully implemented dataware house and data mining, and by its help they have been able to increase their business or sale etc etc help will really be appreciated Tag: Drop database on a different SQL Server.
  - 14
    - Aggregation wizard I changed my data source tables to views which effectively reduced the number of rows being loaded into dimension to only those items that appear in the fact table. However, in the Aggregation Wizard, when I request a row count, it appears that the wizard is not looking at the view, but the original table. Is this possible Thanks, Sully Tag: Drop database on a different SQL Server.
  - 15
    - USING SSIS for scheduled import Mike Kim wrote: Hi msdn forum members, I need to import data from another server using Express edition every minute. So I ran the import wizard, and I saved the packaged on the hard drive. Then when I try to make a new job and new schedule for scheduling, I can't seem to find SQL server integration service option for the Type. does anybody have any idea why I can't see SSIS there or had the same problem Or is there another way of importing data every minuite other than this BTW my server is 2005 standard edition. Thanks in advance, Mike Kim SSIS is not included in Express Edition. Check the comparisons page: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx EDIT: Also, if you are using this on your standard edition server, you will need to make sure that you have installed integration services (it is different than the database engine and needs to be specifically installed) Tag: Drop database on a different SQL Server.
  - 16
    - Monitor network resources used by single database Hi, Is there any methord to monitor network utilization per database on single instance of SQLServer2005 or SQLServer2000. Please help Regards Mohd Sufian Tag: Drop database on a different SQL Server.
- Next
  - 1
    - replicating UDT's to subscribers how many dba's does it take to change a light bulb stupid mistake. need to change it to true to convert data types like on all our other publications Tag: Drop database on a different SQL Server.
  - 2
    - XQUERY / XPATH versus nodes containing ":"-character Hi, all. I'm having problems using XPATH / XQUERY versus input containing ":" in the node names. Example: Code Snippet <MyData:Output xmlns:MyData=" www.myprovider .com"> <MyData:Provider> <MyData:Property MyData:Name="FirstName">Joe</MyData:Property> </MyData:Provider> </MyData:Output> T-SQL (breaks): Code Snippet SELECT XMLContents.query('/MyData:Output/MyData:Provider') FROM dbo.Some_Table __________________________________________________________ XQuery [dbo.Some_Table.XMLContents.query()]: The name "MyData" does not denote a namespace. However, if I remove all the "MyData:" references from code and data, it works fine. I don't have an option of getting the incoming data changed; is there a way to escape the character to get this code to work Tag: Drop database on a different SQL Server.
  - 3
    - SQL Server vs. XML Configurations I have 2 connections in the package. One is development.sa and the other is development.ssisconfigurations.sa. I have the configuration set to define the development.sa properties, which I want to use for a number of the packages i create. My guess is that I am just missing something obvious, but it does not seem like I am. Sam Tag: Drop database on a different SQL Server.
  - 4
    - converting to numeric (6,3) Hey guys, I am trying to achive the following: Truncate the values 1680.390000000000000000 to numeric (6,3) All works ok until i hit a value over 1000, (as above) The code i was using is: cos1 = 1680.390000000000000000000 CONVERT (NUMERIC(6 , 3), ROUND(COS1, 3)) I have tried a few others, but nothing seems to work.. I get the following error. "Arithmatic Overflow" Has anyone got any suggestions Thanks guys, Scotty Tag: Drop database on a different SQL Server.
  - 5
    - Datasource Views and Teradata I'm trying to to use SSAS 05 w/ our Teradata warehouse (VERSION 05.01.02.70 RELEASE V2R.05.01.02.40) and I'm having a problem creating datasource views. My issue is that the wizard returns every view and table in the warehouse (tens of thousands) which takes over 10 minutes . I can't seem to limit it to only the database I'm intersted in using. I've tried using the restrict schema option but then no objects are returned. Any ideas on how to do this Can you create the datasource views without the wizard Thanks. Tag: Drop database on a different SQL Server.
  - 6
    - Understanding code created by SSIS import/export Wizard I can't seem to find these options in any of the designer areas otherwise I would have done that. I assume the logic is in the transfer tasks or somewhere in the foreach loop but there aren't setting for these specific options. I can't tell where it's getting its list of tables to transfer for the export/import either.From what I can tell the settings for deleting or appending rows during the import and allowing identity insert are stored somewhere else. Tag: Drop database on a different SQL Server.
  - 7
    - SQL Server 2005 Service Pack 2 - RTM - WHEN??? Hi, Does anybody know how many CTPs will be provided before the RTM will be delivered Thanks Tag: Drop database on a different SQL Server.
  - 8
    - Parameterized Queries Just getting started using SSce and having a few problems What I want to do is something like this... Dim Code As Integer Dim Description As String = txtDescription.Text.Trim Dim conn As SqlCeConnection = ConnectToLocalDatabase() Dim ssql As New System.Text.StringBuilder ssql.AppendLine( "INSERT INTO T_Titles (Description)" ) ssql.AppendLine( "VALUES(@Description)" ) ssql.AppendLine( "SELECT @Code = @@IDENTITY" ) Dim cmd As New SqlCeCommand(ssql.ToString, conn) Dim sqlCode As New SqlCeParameter( "@Code" , 0) sqlCode.Direction = ParameterDirection.InputOutput cmd.Parameters.Add(sqlCode) cmd.Parameters.Add( New SqlCeParameter( "@Description" , Description)) cmd.ExecuteNonQuery() Code = CInt (sqlCode.Value) ********************************************************************** The above code doesnt work. Firstly I am not sure if I can execute the two statements in one go. Secondly, I am not sure if output parameters are supported. I have been working with SQL Server since 6.5 but have always used sprocs and am feeling a little lost here without them. Any help getting started would be greatly appreciated. Thanks Tag: Drop database on a different SQL Server.
  - 9
    - Users and Roles script In 2005, is there a way to automate this I'd like to be able to do this automatically periodically: 1) Script out the development users and their roles in my development database 2) Backup the production database and restore the it to the development database 3) Re-synch the existing users (sp_change_users_login), drop any obsolete users (sp_dropuser), and add any development users with roles back on Does anyone have a script that can help me achieve this Tag: Drop database on a different SQL Server.
  - 10
    - how to extract this text? I have options_field contains a lot of data.. here are examples: DTбдNBбдNMбдANI=80088080 39139662 ANI=80088080 36637576 бдDNIS=80088080бдDTбдNBбдNMбдUNIT ANI=80088080 39188390 бдANI=8008808017403125бдDNIS=80088080бдDTбдNBбдNMбдUNIT ANI=80088080 39653135 бдALIASбдDNIS=80088080бдDTбдNBбдNMбдUNIT ALIASбдANI=80088080 39169467 бдANI=8008808017326875бдUNITбдNMбдNBбдDTбдDNIS=80088080 DTбдNBбдNMбдDNIS=80088080бдANI=80088080 36331200 бдANI=80088080 39318646 I want to extract every 39 and 36 mobile numbers in the ANI. All numbers are 8digits as highlighted ad some records will have more than mobile number while some won't have any mobile number listed. so the result should be 39139662 36637576 39188390 39653135 39169467 36331200 - 39318646 Tag: Drop database on a different SQL Server.
  - 11
    - Differences in varchar size usage, declaring the maximum available of 8000 characters Cool work there, I got you. For the table, I think it's pretty straightforward where it is only storing the exact string (length) with some overhead. So for variable/parameter in memory, the memory space is actually a dynamic one (where it can grow or something else), but SQL Server is smart enough to allocate a size that should optimize the situation. I guess my understanding should be correct, right I use both SQL Server 2000 and SQL Server 2005. Thanks, it helps. Eugene Tag: Drop database on a different SQL Server.
  - 12
    - Daylight Saving Time DST 2007 Problems Yes. That's right. Tag: Drop database on a different SQL Server.
  - 13
    - end conversation : security context could not be retrieved what is the event subclass Tag: Drop database on a different SQL Server.
  - 14
    - Unicode causes Dimension build failure? Yes, I guess so. Have you tried using a Chinese collation Tag: Drop database on a different SQL Server.
  - 15
    - Change member properties order in excel 2007 pivot table Hi everyone, i am trying to change the member properties order in a excel 2007 pivot table but it wont work... I've found how i should do it according to Microsoft Office web site ( http://office.microsoft.com/en-us/excel/HA101777521033.aspx , see : Display member properties as data in a PivotTable report ) but even if i follow the instruction by the letter it is not working... I've searched a lot but i can't find anything on this... Anybody's having the same issues or know a way around it I'm using SSAS 2005 SP2 and Excel 2007 Thank you very much! Tag: Drop database on a different SQL Server.
  - 16
    - SQL Server 2005 Limitation: Having many attributes for Neural Network You should make the attributes you want to predict case level attributes and put all of the other attributes in a nested table which will be input only. For example "Friendly" and "Rich" will be case level attributes with values 0 or 1 and the other attributes will just be nested keys, e.g. something like this. CREATE MINING STRUCTURE DatingStructure ( [UserID] LONG KEY, Friendly LONG DISCRETE, Rich LONG DISCRETE, Attributes TABLE ( Attribute TEXT KEY ) ) ALTER MINING STRUCTURE DatingStructure ADD MINING MODEL DatingModel ( UserID, Friendly PREDICT, Rich PREDICT, Attributes (Attribute) ) USING Microsoft_Neural_Nets You will need two tables - one that has the UserId and the first two columns for each case, and the second that is a transactional table containing a column for the UserId and the Attribute name. Note that if you have the same user twice, you will need a different userid for each one to represent that user. Eg. Simon1 and Simon2 or whatever. Usually you can make a compound key by appending two columns (e.g. the name and the date). The only requirement is that the UserID in the case table and the UserID in the nested table match. Tag: Drop database on a different SQL Server.

Kawaldeep Singh

Hi,

I am new to SQL Server 2005.Till now, I have been using a SP to execute DROP DATABASE command to drop databases on my existing database server.

but now i want to delete a database which is on a different SQL Server 2005 instance on a different machine. but i am not sure how to do this.

Can anyone please help me on this

Any help would be appreciated.

Thanx in advance.

Kawal

Re: Drop database on a different SQL Server.

Manivannan.D.Sekaran

If you have the remote server credential connect your SQL Mang. Studio with the target server & execute the same script.

Re: Drop database on a different SQL Server.

Kawaldeep Singh

Thanks for the reply!

i can do that but my problem is different.

I am deleting database from my application which calls a VB component to delete the database. SP is called from this VB component and this SP resides on Admin DB which is on , say server1. database that has to be deleted is on a different server running a different SQL Server instance.

Is this thing possible in any way

Waiting for your reply.

Re: Drop database on a different SQL Server.

zuomin

As far as I know, in this case, you have to recreate the sproc on target server.

Re: Drop database on a different SQL Server.

Kawaldeep Singh

and can you please tell how to do that as i tols earlier, i am new to SQL Server