SQL Server 2005 Express

SQL Server Express

Index ‹ SQL Server

- Previous
  - 1
    - accessing static methods of a .net dll, but from sql2000? Is this somehow possible Tag: SQL Server 2005 Express
  - 2
    - A call to SQL Server Reconciler failed. SQL Server 2005, SQL Server Mobile merge replication Hello... I had the same problem the past few days...and what solved it for me was two things: 1. making sure that the windows user accounts for the replication had read/write control of the replication problems. 2. making sure that those windows user accounts (and my one sql login account that is used for anonymous access) were in the Publication Access List for the publication. Tag: SQL Server 2005 Express
  - 3
    - Data restore help The database server crashed and i am trying to restore database. I have all the mdf, ldf and bak files. I tried to attach, import and restore but nothing is working. It just gives this error, TITLE: Microsoft SQL Server Management Studio An Exception occurred while executing a Transact-SQL statement or batch (Microsoft.Sqlserver.ConnectionInfo) Additional Information: The media family on device 'D:\Databases\inv.bak' is incorrectly formed. SQL Server cannont process this media family. RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241) Anyone, please help. Thanks Subasis Tag: SQL Server 2005 Express
  - 4
    - categories table hi to all; i want to make in my site the possibility for the user to make categories in the site ex: he can add the category name"computer science" and then can add the category childs " data mining, software engineering,... " so firstly i want to make a category table in my databasde to be able to save the category data haw can i make this table i mean what are the columns that should be in the table what type of relationship should i make and how to mahe it sorry but i need any one to explain to me what should i do. and if anyone one know the solution please reply to me thanks.... Tag: SQL Server 2005 Express
  - 5
    - Could not find stored procedure I can't recall the srx number, nor the date I opened it. The work around was to deploy all the subscribers. That involved dropping all existing subscribers and resyncing. I am not sure if the MS guy was able to repro the problem or solve the bug. You would have to call Microsoft and mention my name and have them search on it. Perhpas one of the MS guys who hang out here could seach the RAID database for it. Tag: SQL Server 2005 Express
  - 6
    - How to deploy an report and connection string from some xml file You can create an expression based connection by going to the data tab of your report. Open up the dataset properties (by clicking the ellipsis (...) beside the dataset dropdown), and then click the ellipsis next to the data source. If the Use shared reference option is checked, uncheck it. You should then be able to select the fx button next to the connection string box. You can enter an expression into the resulting dialog, such as: Dynamic Connection String ="Data Source="+Parameters!Server.Value+";Initial Catalog="+Parameters!Database.Value You'll need to create the parameters on the report to hold the values you want, and you may need to alter the connection string in my example to match your database provider. Hope this helps. Tag: SQL Server 2005 Express
  - 7
    - Help sorting a Recursive Query Simple, as per your requirement you have to sort with Path. Instead of the Name you want to use the Id of the each node. You already have the ‘named’ path. But that won’t suite for your requirement. So I created on more path with ID. Since Id is a integer I made the numbers as same length (adding 100000). So when you create a path with id & use it for the sorting your desired result came. Tag: SQL Server 2005 Express
  - 8
    - "Select * from Table" is processed much faster than "Select MyField from Table" ???? Well, I have a problem and the problem is that I cannot reproduce the performance issue anymore. Now both statements take the same time to finish (as it was expected). I don't know wich server conditions caused the performance difference. Ben: The problem was that the Select MyField performed much slower than the Select *, and MyField is the primary key of the table so it should use the index in this case Sankar: The query want to return all the nodes where a user (or any of its roles) has a specific permission. The nodes are structured hierarchically, similar to the filesystem where you inherit permissions from the parent folder. In this case you have to do four checks 1 Add any node that the user has permission in any parent node (that has the flag ApplyInheritance=1 that indicates that the permission should be inherited) 2 Add any node that the user has permission directly in it (doesn't mather the ApplyInheritance attribute) 3 Remove from the result set any node that has the permission denied directly (permissions could be allowed or denied) 4 Remove from the result set any node that has the permission denied in any parent node, and is marked to applyInheritance to its children (Permission denied and ApplyInheritance=1) If you still think that the query is not correct let me know which could be a better solution to this problem Now I cannot reproduce the problem, I'm just courious when it's going to happen again Thank you! Tag: SQL Server 2005 Express
  - 9
    - Usage Based Optimization - Problem Hi everyone I'm trying to set my aggregations through the usage based optimization tool on sql server 2000 I have about 25 users active using my viewer (panorama) and when i'm trying to filter my data on the first step of the Usage Based Optimization wizard i get no result can anybody tell my howcome no statistics is shown thanks......... Tag: SQL Server 2005 Express
  - 10
    - DTS problem on 64-bit installation Is there solution of the DTS problem for Vista 64-bit The one below doesn’t work for 64-bit installation. Tag: SQL Server 2005 Express
  - 11
    - Can I change from Integrated Security? When creating my database, I initially set it up to use Integrated Security (Windows Login), however I am having a hard time logging into the database on a consistent basis using this method. Can I now change to a specified user id and password How would I do that Would I lose any data in my database Does the user id and password need to be the same user id and password used when logging into SQL Server Thank you. Tag: SQL Server 2005 Express
  - 12
    - Remove SP1 or install SP2 Dec. CTP Gary, you're right that the service packs show up in Add/Remove Programs when you click on "Show Updates", but the "Remove" button is missing. SQL Server does not support uninstall of Service Packs at this time. Thanks, Sam Lester (MSFT) Tag: SQL Server 2005 Express
  - 13
    - Insert Identity value with SqlCeResultSet Hi I have a table with an identity column. This is set to increase by 1 and start on 1, and is the first column of the table. When I insert a record into the resultset, I get an error stating that it can't be DbNull. Th record is created from a resultset with the query "Select * from table", so the id should be included But as I understand it, it should be increasing automatically, right Becuase that's the behaviour of the normal sql Insert command. I have seen an article that just left the id column in the record alone before inserting it, but it didn't help me. How can I sidestep this issue Tag: SQL Server 2005 Express
  - 14
    - Add Reference to Excel in Scripting tool in SSIS 2005 How can I add a reference to the Microsoft excel 2003 in the script tool in SSIS 2005 I need to automate Excel for formatting. Thank you. Dan Tag: SQL Server 2005 Express
  - 15
    - How to change the target table name in SSIS package(not designed from scratch but was migrated) When i succesfully migrated it from DTS to SSIS. it shows taks as "Execute DTS 2000 Package Task" in control flow tab. and at bottom it shows two connection manger , one for my Source TXT file, and one for destination SQL Server database. and what I am looking for editing Destination parameters. Thanks, Tag: SQL Server 2005 Express
  - 16
    - Inconsistency between Data Source Designer and underlying code I have 2 data sources that have recently been updated from SQL Express to full versions of 2005. The connection strings have been changed, and the changes appear in the code, but the data source designer still shows the SQLExpress portion of the connection string. This seems to be fouling up SSIS packages that are using these data sources. Has anyone else encountered this If so, what can I do to fix this issue Tag: SQL Server 2005 Express
- Next
  - 1
    - Increase Transaction Log size Hi, How can I increase the transaction log size of my sql server 2005 database i can execute the shrink and backup log which can shrink the .ldf file to 1MB. However, since my dts involves a lot of inserts and updates, the my transaction log grows to 700MB in the middle of my dts execution. How can i increase the transaction log size maximum capacity to probably 1.5GB just so it can accommodate my full dts execution BTW, this is my commands to shrink the log file: DBCC SHRINKFILE ( <dbname>_log , 1 ) BACKUP LOG <dbname> WITH NO_LOG DBCC SHRINKFILE ( <dbname>_log , 1 ) cherriesh Tag: SQL Server 2005 Express
  - 2
    - top 10 accounts for every day with summary hi, i am new to mdx and stuck on a problem on analysis services 2005. there is an orders cube with calendar and accounts dimension. the report i want to do is something like this date account quantity top10percentage 01.01.2007 All 1000 85 bnm 230 23 abc 150 15 bbc 140 14 aaa 100 10 wer 60 6 rrr 40 4 xyz 35 3,5 xtv 35 3,5 tyu 30 3 tbh 30 3 02.01.2007 All 1230 75 abc 150 15 bnm 150 15 bbc 140 14 aaa 100 10 txp 60 6 rrr 40 4 xyz 30 3 xtv 30 3 tyu 25 2,5 tbh 25 2,5 i have written a calculated member for the percentage of the account for that day's total order amount. but when i do a filter on accounts dimension to get top 10 records for that day in excel 2007 the total value of the percentage for that day remains 100. not the sum of the top 10 records percentage values. i am looking a way to write a report like this and appreciate any suggestions. and also any workaround to solve this excel behaviour. thanks in advance Tag: SQL Server 2005 Express
  - 3
    - Improving Performance well nearly of the queries are ordered by Date DESC, to look at the most recent events first and alot of them are asking for specific eventIDs, or IDs that are not in a set and alot of them are searching with a LIKE clause on the message column and alot of them are searching for a specific username or a specific type column, which holds the (Application, System, or Security) the source is looking for particular problems, but it isn't used as much as the rest. the categoy isn't used very much at all all of it is pretty muched used. i've read a little bit about query strategies but i'm not comming up with much b/c pretty much all of the data is queried for on one way or another. My best guess at an order of importance would go like this EventID Date Message Type Computer Source UserName Category Right now this is one index on Date, and the index is ordered by DESC. But that still didn't improve the performance at all, or at least it didn't improve the performance enough to where it wouldn't time out on everything. Sample Queries Get Yesturdays Application Errors SELECT * From EventLogsTable Where Log == "Application" and Type = "Error" Order by Date DESC Most Event Generating Users Select UserName, Count(*) from EventLogsTable Where UserName is NOT in ( ' ', 'NTAUTHORITY', 'Administrator' ) Group By Count(*) Order by count(*) DESC Important Event IDs Select * From EventLogsTable where EventID is in ( 'Several Event IDs here' ) order by Date DESC or just any specific peice of information to help narrow down to get to what we are looking for at that particular moment. I was also thinking about, since most of the data is plain text, like the Message column i was wondering if enabling full text search on that column would help. i was hoping the full text catalog would help imporve the performance of it. but I don't know if the full text catalog is used only for particular queries like queries with the CONTAINS clause in it, or if the LIKE clause will go through the catalog or just if any more queries from that point the catalog is created and indexed. not sure I hope this helps Tag: SQL Server 2005 Express
  - 4
    - Copy objects with DTS Import/Export Wizard? I am getting very frustrated, for two days now I've been trying to work out how to copy a database (SQL express version) to my ISP which has the full MS 2005 server. I keep losing keys, stored procedures etc. When you right click on the database as you say and click on tasks there's no copy database there. Tag: SQL Server 2005 Express
  - 5
    - Problem with the SQL Insert with .CommandText() and .ExecuteNonQuery() Hi I have done a SQL statement INSERT for my coding. The program compiled and run the insertion with no error occurred. But after the compilation I found out that my database is not populated at all. I tried the data insertion using the manual query, and I work perfectly. So the problem now is that I do not know why my codes did not insert the data into my database. Will like to get some advise. Thanks My codes are pasted in http://www.pastebin. ca/320102 The Debug.Writeline in the code is in http://www.pastebin. ca/320108 Thanks again. Tag: SQL Server 2005 Express
  - 6
    - Select Statement In Table (Valid Expressions Error). We are currently implimenting row level security by putting part of the Customer's account information in a DB Table. I have been able to do this on a case by case (individual customer) basis, but I tried to script inserting a whole bunch of customers at once using a script. When I run the script just using print commands, everything looks fine. When I run it to actually process the data, things bomb out. Example Customer Table being sent to me: Name AccountNo ----- ----------- abc A5071 def 57791 ghi 8W551 jkl 07A11 & 13866 mno 015X1, 0725A, 07551 Note there can be more than one leading zero in the accountNo. So I want my new table ("New_Cust_Table") to look like: UserId Pwd SelectStmt ------ ------ ------------------------------- abc1 abc1# And AccountNo LIKE '%A5R7' def1 def1# And AccountNo LIKE '%5779' ghi1 ghi1# And AccountNo LIKE '%8W55' jkl1 jkl1# And (AccountNo Like '%07A11' OR Account LIKE '%13866') ... etc. Ignoring the Cust Names with multiple Account numbers for the moment, my SQL Looks like this: -- DECLARE VARIABLES DECLARE @UserID varchar(20) DECLARE @UserPwd varchar(20) DECLARE @SelectStmt varchar(200) DECLARE NewCustUser CURSOR FOR SELECT Name, AccountNo FROM Cust_Table OPEN NewCustUser FETCH NEXT FROM NewCustUser INTO @UserID @SelectStmt WHILE (@@FETCH_STATUS = 0) BEGIN IF (LEN(@SelectStmt) <= 6) -- ACTUALLY GET MULTIPLE ACCOUNT Nos for ONE Customer Begin Print 'Account is ' +@SelectStmt+' for '+@UserID SET @SelectStmt = 'AND AccountNo LIKE ''%'+@SelectStmt+'''' Print @SelectStmt SET @Statement = N'INSERT INTO [dbo].[New_Cust_Table] VALUES ( '''+@UserID+'1'','''+@UserID+'1#'','''+@SelectStmt+''')' Print @Statement EXEC sp_executesql @Statement END FETCH NEXT FROM NewCustUser INTO @UserID @SelectStmt END CLOSE NewCustUser DEALLOCATE NewCustUser Some of the error message I get: - Incorrect syntax near ''. - The name "A5R7" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted. Perhaps there is a CAST, CONVERT or COLLATE is needed I have experimented with those and have not found anything that works just right yet... Tag: SQL Server 2005 Express
  - 7
    - Why does using the "in" clause cause an error in my "Having" condition in 2000, but not 2005? What about the error msg AMB Tag: SQL Server 2005 Express
  - 8
    - Dose anybody knows how to use MergeJoin component programitcally? I'm building a package programitcally and I can't find any document which shows how to work with MergeJoin component in code. Please help, Thanks Tag: SQL Server 2005 Express
  - 9
    - SQL Server 2005 SP2 cannot be installed because the Database Engine setup remains in suspended installation mode SP2 refuses to install for the Database Engine because “the previous upgrade did not complete”, i.e. it detects a suspended installation. The same thing happened to me when I installed SP1. I then remember opening the maintenance dialog and completing the setup, after which SP1 installed just fine. When I try to do the same thing this time, I’m presented with the ”complete the suspended installation” option, which when I run it reports the installation completed successfully. However, in reality the installation still remains in suspended mode for whatever reason. If I reboot and open the maintenance dialog, I’m still presented with the ”complete the suspended installation” option. I’ve even tried to run it more than once, but it doesn’t help. Needless to say, SP2 still refuses to install. I don't know why the installation is in a suspended state. I know every part of SP1 installed successfully in the end, and the computer never crashed during the installation. I've been using it every day since then, without any problems. All other parts of SP2 did install successfully. I created a feedback entry on Microsoft Connect, where you can find the log files created by Windows Installer. The URL is: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=259606 Any ideas what I can do to resolve this problem Tag: SQL Server 2005 Express
  - 10
    - patindex with nvarchar yeah thanks for your help,but can you check my storedProcedure as well Please look at it & if you have any idea of it. ________________________________ SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO -- -- spSearch -- SUMMARY Executes a search using the specified query -- PARAMS @siteId Identifier of the site from which the search request was generated -- @query Full-text query to be executed against the full-text engine -- ALTER PROCEDURE spSearch ( @siteId INT, @textOnly BIT, @query NVARCHAR(4000) ) AS -- Select Alternatives Declare @partialQuery NVARCHAR(50) Declare @keyphrase NVARCHAR(50) --Query can be provided like 'searchterm' or as "search term" depending in existance of space character --must format the partial query if it contains a space like '"search term*"' --the keyphrase is @query without quotes IF CHARINDEX(N'"',@query) > 0 BEGIN SET @partialQuery = LEFT(@query, LEN(@query) - 1) + N'*"' SET @keyphrase = LEFT(RIGHT(@query, LEN(@query) - 1), LEN(@query) - 2) END ELSE BEGIN --must format the partial query like '"searchterm*"' set @partialQuery = N' "' + @query + N'*" ' set @keyphrase = @query END --Now we can search for alternatives as exact match of @query on alternatives --or partial match on keyword, but ignore exact match on keyword (i.e. only alternatives to @query) SELECT * FROM tblKeywords WHERE NOT Keyword = @keyphrase AND SiteId = @siteId AND ( CONTAINS(Keyword, @partialQuery ) ) -- Select the pages that match the query SELECT DISTINCT c.ContentName, c.ContentLongSummary, c.MasterId, nc.NavigationId FROM tblContents AS c INNER JOIN trelKeywords AS ck ON ck.MasterId = c.MasterId INNER JOIN tblKeywords AS k ON k.KeywordId = ck.KeywordId INNER JOIN trelNavigationContents AS nc ON nc.MasterId = c.MasterId INNER JOIN GetKeywordsFromQuery (@query) AS kq ON kq.Word = k.Keyword INNER JOIN tblNavigation AS nav ON nc.NavigationId = nav.NavigationId WHERE c.SiteId = @siteId AND c.StatusID = 2 AND c.DeletedBy IS NULL AND ( (@textOnly=0) or (nav.ExcludeFromTextSite=0 and @textOnly=1) ) UNION -- the following selects list pages that match, with primarylist page as their navigationid SELECT DISTINCT c.ContentName, c.ContentLongSummary, c.MasterId, nc.NavigationId FROM tblContents AS c INNER JOIN trelKeywords AS ck ON ck.MasterId = c.MasterId INNER JOIN tblKeywords AS k ON k.KeywordId = ck.KeywordId INNER JOIN tblContents AS c1 ON c.PrimaryListMasterId = c1.MasterId INNER JOIN trelNavigationContents AS nc ON nc.MasterId = c1.MasterId INNER JOIN GetKeywordsFromQuery (@query) AS kq ON kq.Word = k.Keyword INNER JOIN tblNavigation AS nav ON nc.NavigationId = nav.NavigationId INNER JOIN tblListContents AS lst ON lst.ListItemMasterId = c.MasterId WHERE c.SiteId = @siteId AND c.DeletedBy IS NULL AND c.StatusID = 2 AND c1.statusid = 2 AND c1.DeletedBy IS NULL AND ( (@textOnly=0) or (nav.ExcludeFromTextSite=0 and @textOnly=1) ) AND lst.ContentMasterId = c.PrimaryListMasterId -- Select the downloads that match the query SELECT DISTINCT r.ResourceId, r.ResourceName, r.ResourceLongSummary, r.FileSize FROM tblResources AS r INNER JOIN trelKeywordResources AS kr ON kr.ResourceId = r.ResourceId INNER JOIN tblKeywords AS k ON k.KeywordId = kr.KeywordId INNER JOIN GetKeywordsFromQuery (@query) AS kq ON kq.Word = k.Keyword INNER JOIN trelContentItemResources AS cir ON r.ResourceId = cir.ResourceId WHERE r.ResourceTypeId = 2 AND r.SiteId = @siteId AND cir.StatusId = 2 SELECT CASE WHEN nc.MasterId IS NULL THEN cir.MasterId ELSE nc.MasterId END AS MasterId, CASE WHEN nc.MasterId IS NULL THEN ln.NavigationId ELSE nc.NavigationId END AS NavigationId, c.ContentName, res.ResourceId, res.ResourceTextType, res.ResourceText, c.ContentLongSummary FROM tblResources res INNER JOIN trelContentItemResources cir ON cir.ResourceId = res.ResourceId LEFT OUTER JOIN trelNavigationContents nc ON nc.MasterId = cir.MasterId LEFT OUTER JOIN tblContents c ON c.MasterId = cir.MasterId AND c.StatusId = cir.StatusId LEFT OUTER JOIN trelNavigationContents ln ON c.PrimaryListMasterId = ln.MasterId LEFT OUTER JOIN tblNavigation nav ON nc.NavigationId = nav.NavigationId INNER JOIN tlkpResourceTypes rt ON rt.ResourceTypeId = res.ResourceTypeId INNER JOIN tblListContents AS lst ON lst.ListItemMasterId = c.MasterId WHERE (res.SiteId = @siteId) AND (res.ResourceTypeId = 1 OR res.ResourceTypeId = 6) AND CONTAINS(res.ResourceText, @query) AND (c.ContentPublicationDate IS NOT NULL) AND (c.DeletedBy IS NULL) AND (c.StatusId = 2) AND (nc.MasterId IS NOT NULL) AND ( (@textOnly=0) or (nav.ExcludeFromTextSite=0 and @textOnly=1) ) OR (res.SiteId = @siteId) AND (res.ResourceTypeId = 1 OR res.ResourceTypeId = 6) AND CONTAINS(res.ResourceText, @query) AND (c.ContentPublicationDate IS NOT NULL) AND (c.DeletedBy IS NULL) AND (c.StatusId = 2) AND (c.PrimaryListMasterId IS NOT NULL) AND ( (@textOnly=0) or (nav.ExcludeFromTextSite=0 and @textOnly=1) ) ORDER BY rt.SearchResultOrder, c.ContentName GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO __________________________________________ you call the SP you should prefix the N in this sp, i m using three times that function. even i m not getting how to call the sp with it should have prefix the N....please let me know. i am just waiting for your reply.even i have using NVARCHAR whereever i stored a hindi text...i hope you have already seen my function.please do the needful. i have tried lot since few days on this, still couldn't get the right solution. Tag: SQL Server 2005 Express
  - 11
    - MDX Ranking Question Thanks for all the help! That is working fine, and is not too slow. It is not a commonly used calc so shouldn't pose a problem. Tag: SQL Server 2005 Express
  - 12
    - BCP loading failing on timeout error Hi Paul, what about the version of MDAC . . . for both! CU tosc Tag: SQL Server 2005 Express
  - 13
    - allows blank value for integer Parameter Hi have a problem to solve and I hope that this is not a SSRS Bug. I created a Reports(using SQL Server Project) which has several parameters which values are passed to a SP. One of these parameter is an Integer and it is an optional value, so if the user fill it is used by the SP, otherwise the SP uses NULL and run anyway. I starts to define tha parameter: Datatype = integer Allow blank value Available: Non queried Default: Null if I want to Preview the report I have to provide an integer to the parameter's field ... If for instance I set: Default: Not queried = 0 In the moment I deploy and I use the ReportViewer in my window application the parameter's field is unabled!! So I tried this solution: Datatype = integer Allow blank value Allow null value Available: Non queried Default: Null In the preview the checkbox: NULL is checked and I click on the View Report. But when I deploy it,in the ReportViewer in my window application the parameter's field this checkbox is unchecked. Do I forget something during my setting I have to control it programmatically N.B. By default the user will not user this parameter so the best is that he can click directly on "View Report" without any additional "work" on the parameter!! Thank you for any help! Tag: SQL Server 2005 Express
  - 14
    - No one can help me on this prolem?????? Does somebody know how to handle it Thanks, Jone Tag: SQL Server 2005 Express
  - 15
    - SSIS deployment - redefined It seems that I cannot create one config file for all of my packages because not all of them use the same connection managers. In other words, if I use a config file for a package that does not contain a certain connection manager specified in the config file, the package throws an error in loading. Is this correct Tag: SQL Server 2005 Express
  - 16
    - Merge Replication (Push) over Internet Hi all, I was wondering if someone could suggest a solution to my problem: I have an in-house production database. I wanted to use Merge replication (push) to mirror parts of this data to our Internet server on the web which has a Public IP. Steps I followed 1. Created an entry in “C:\WINNT\system32\drivers\etc\hosts” file with IP address of the Subscriber and just the “Servername” of the Subscriber on publisher machine (local server) 2. Created an Alias to the Subscriber 3. Connected to the remote server thru Mgt Studio 4. Created Merge Replication on the Local Database 5. Created Subscription to the remote server. 6. Started the Replication Agent I receive following msg " The process could not connect to Subscriber 'ISVR'. When I check the View Synchronization Status in Mgt studio it shows "The server 'ISVR' is not a Subscriber" I presume that if we have a Public IP at our end, then the Merge Replication will be thru. Is it possible to replicate without having a Public IP Any suggestions, Thanks. Tag: SQL Server 2005 Express

myghetto

Is there no way in SQL Server Management Studio 2005 Express (SSMSE) to migrate the data only to an already provisioned database on another server

Top

Re: SQL Server 2005 Express

Andrea Montanari

hi,

no, there' not.. SSMSE does not include DTS or SSIS features to perform ETL (extract-transform-load) tasks...

you have to "move" (copying it or backing it up and restoring it) your db to the other server, or, via Linked Server (if the 2 machines are reachable on the net) you can perform INSERT... SELECT across database and server boundaries..

regards

Top