Answer Questions

• Arkady Frenkel What's unallocated space

  I seem to have a lot of unallocated space in my SQL server 2005 database. I have shrank the database and also rebuilt every index checking the fragmentation of each. I can't seem to get rid of this unallocated space. Using the summary report from SQL Server Management Studio the break down of my database is Index Space 19.87% Data Space 43.43% Unallocated Space 34.71% Unused Space 1.99% Here is the command I used to rebuild the index which works really good (just be aware it will drop the index so dont run it during work hours). sp_msforeachtable @command1 = ' PRINT ''Starting ''' , @command2 = 'ALTER INDEX ALL ON REBUILD' , @command3 = ' PRINT ''Completed ''' TSQL is USE [ ...Show All

• IBLUES weird resultset from stored procedure

  I have 2 stored procedures: the 1st uses the second sp. to fill a parameter. the 2nd has one output parameter defined. When I run the 2nd sp. on its own in MS SQL Server Manangement studio, there is no resultset shown. BUT when the 2nd sp. is executed inside the 1st sp., I get a '3' in the resultset everytime the 2nd sp. executes. What is causing this This is the way I execute the 2nd sp. inside the 1st sp.: select 'TEST1' execute dbo . uspMonthlyHeadCount @soe , @eoe , @Months , @count output select 'TEST2' Results are like this: TEST1 3 TEST2 ... (it's displayed more times because the sp. is inside a while) Why is this happening and what can I do about it (I'll provide more info if needed!) ...Show All

• jam281 Adding a 2nd subscrber makes my Merge replication blow up.

  I have two machines running SQL Express that I am attempting to use as proxies for a client application as the security admin has deemed that outside clients can not connect directly to the main DB servers. When I have one of the SQL Express boxes subscribed to my SQL 2005 standard server, everything is happy, but when I attempt to add the second SQL Express box as a subscriber, everything seems to blow up. OK, I'm setup as a merge with updates and no filter since I want all of the servers to get all of the data. I'm also on a non-standard port but have my aliases setup, and I don't have any connection issues. When I run the subscription wizard from the management studio, it comes back with "Success", but about 2 seconds la ...Show All

• mihe dataMining

  i create a model mining to know percent of product, which is like more by customer is have percent biger than other products that is don't like by customer. i use DTS to get result to sql server. select flattened predict([modelName].[tablePredict],Include_statistic) from [modelName] prediction join ..... i have result with a table A in sql server: productid $support ... $adjustedprobability 1 0.0 ... 1 0.0 ... 1 63.3 ..... how can i write in Dts so that table A not have record with value $support=0.0 - second: percent people like that product is knowned by $adjustedprobability or $support and value small or big ...Show All

• Guardian-ND SQL SMO Object

  hi all, i'am engaged in migrating the database of one application which is developed in VB6.0 and SQL Server2000 to SQL server2005. Here the client is using the SQL DMO objects of SQL2000 to perform many database data manipulations for the end user, my problem is when i'am connecting the application to SQL2005 that session is ending up with an error. From the compatibility documentations i come to know that we need to use SQL SMO objects instead of SQL DMO , when i checked in msdn online i could only find code to connect to vb.net, can any one provide me information how to use SQL SMO object in VB 6.0..... thanks in advance Mat pls log your issue on http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID= ...Show All

• MariamCR Retrieving multiple rows from data base.

  OK here's my question. I want to retrieve from my database employee table all those employees with the name eg. Smith and display them in a list. Can anyone give me any pointers please. I'm using VB 2005 Express Edition. So far this is what I have but it only seems to return 1 row when I know there are more than one entries with the name I am inputting Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim searchString As String searchString = Me .SearchStringBox.Text Try Dim filter As String filter = "LastName LIKE '" & searchString & "'" Dim search() As System.Data.DataRow search = myCDDataS ...Show All

• cipcip SQL Server Express Limits

  I am trying to understand the limits that are placed on SQL Server 2005 Express Edition. I understand that 4GB is the limit of the data files. This includes tables, indecies, etc. I was wondering if I put tables in different Filegroups does the 4 GB limit still apply as a limit for all filegroups combined, or is it on a per file group limit Also, is the 1 CPU and 1 GB of memory a per instance or per machine limit. For example, can I have two instances on a dual processor machine and use both processors, one for each instance The limit is 4Gb per database (sum of all data files) and 1 Gb and 1 CPU per instance. You can install multiple instances on the dual proc server but there is no way to specify/assig ...Show All

• Guy Ronen Recursive XML import into SQL using SQLXML 4.0

  Hi All Please may i have your assistance with the following issue. My objective is to import the following XML into SQL. My SQL schema is as follows CREATE TABLE object(id varchar(8000) PRIMARY KEY, type varchar(256), name varchar(256), parentid varchar(8000) FOREIGN KEY REFERENCES object(id)) My XSD. < xml version = " 1.0 " encoding = " utf-8 " > < xs:schema targetNamespace = " http://www.bt.com/aai/aos/DataCollector/XLMNS " elementFormDefault = " qualified " xmlns = " http://www.bt.com/aai/aos/DataCollector/XLMNS " xmlns:mstns = " http://tempuri.org/XMLSchema.xsd " xmlns:xs = " http://www.w3.org/2001/XMLSchema " xmlns:msdata = " urn:schemas-microsoft-com:xml-msdata " xmlns:xsd = " http: ...Show All

• mruniqueid Trouble Installing SQL SERVER 2000 SP4

  Any help "Greatly" appreciated. When trying to install SP4, I do not receive any notification of the install i.e. click on setup and then nothing. Checked *.out log and receive the following: 2006-08-08 10:40:57 - [100] Microsoft SQLServerAgent version 8.00.194 (x86 unicode retail build) : Process ID 3616 2006-08-08 10:40:57 - [101] SQL Server 1LTZ0Q version 8.00.194 (0 connection limit) 2006-08-08 10:40:57 - [102] SQL Server ODBC driver version 3.81.9031 2006-08-08 10:40:57 - [103] NetLib being used by driver is DBMSSHRN.DLL; Local host server is (local) 2006-08-08 10:40:57 - [310] 2 processor(s) and 1016 MB RAM detected 2006-08-08 10:40:57 - [339] Local computer is 1LTZ0Q running Windows NT 5.0 (2195) Service Pack 4 2 ...Show All

• Mukhtar Database security on a Local Network

  This is regarding general protection of a database hosted on a network. I am developing a database application for my college library using VB.NET, that will reside on a network. For some reasons, I did not want to hardcode the Database location in the application. Instead, when a user logs in, he can choose the database location using a folder browser control, if the location has changed. Now, I realize that for this, I have to put the database in a shared folder, which makes it quite vulnerable. Having pondered over the problem for sometime, a solution that comes to my mind is to place a Text file in the same shared folder that always contains the correct path of the database. When a user chooses that folder, I will read the actual path ...Show All

• RajaGanapathy Copy a Table

  In MS Access, if I want to copy a table, I can just highlight it, hit ctrl-c and ctrl-v, and VOILA!  I now have a "copy of MyTable" pasted, with all data duplicated. Um.  How do I do the same thing in SQL Server 2005   Can this be done with Server Management Studio   I don't necessarily want to copy relationships to other tables, I just want a stand-alone copy of the table, with a new name, inside the same database. (EDIT): I just noticed I can achieve this outcome with: SELECT * INTO TestIT FROM TestCases ...and while that is simple enough to get the job done, I kinda still wonder if there is a GUI-oriented means to accomplish this (like Access does), without writing bits of SQL as above. the ...Show All

• Vayse_Dev Geting the report url

  Hello. Is there a way in a report to get his url I'll explain what i want to do: I want to add an option to export the report to excel format with out useing the menu so i want to add a button (or a table cell) and give him,in the nevigation field, the same url of the rreport with the same parameters but add to him the command "rs:format=excel" and then by pressing the button it will automaticly export my report. Thanks. I thought it was an easy one :) If my question is not clear enough, please let me know. Thanks. Craft a URL like this: http://localhost/reportserver /ReportProject1/Report&rs:Command=Render&rs:Format=EXCEL Documented at http:// ...Show All

• satya999 /logger option

  Hi, I'm trying to use the below command to execute for generating the log file for SSIS package. DTExec /FILE "C:\Documents and Settings\CP0808\My Documents\Test.dtsx" /logger "DTS.LogProviderTextFile;c:\log.txt" But it got the error as below. Please advise. Started: 10:03:20 AM Error: 2006-10-06 10:03:21.15 Code: 0xC001000E Source: Test Description: The connection "c:\log.txt" is not found . This error is thrown b y Connections collection when the specific connection element is not found. End Error Error: 2006-10-06 10:03:21.18 Code: 0xC001000E Source: Test Description: The connection "c:\log.txt" is not found. This error is thrown b y Connections collection when the specific c ...Show All

• Philippe Delodder TRY... CATCH block does not behave as described or as expected...

  Below you have a piece of code that despite the TRY... CATCH block, has the following result: Msg 4860, Level 16, State 1, Line 4 Cannot bulk load. The file "C:\123.txt" does not exist. BEGIN TRY SELECT count(*) FROM OpenRowSet (BULK 'C:\123.txt', FORMATFILE = 'C:\123.txt.fmt') O END TRY BEGIN CATCH select 'catched' END CATCH select 'done' So why the code never falls into the CATCH block ---------------- Another misbehaviour of the TRY... CATCH BLOCK i in the following example: BEGIN TRY DECLARE @rowcnt int, @error int BULK INSERT [__BULK_UPLOAD_247_20061209_pwgJqAbspG] FROM 'C:\Test\test.txt' WITH ( FORMATFILE = 'C:\Test\test.txt.fmt') SELECT @error = @@error, @rowcnt = @@rowcount END TRY BEGI ...Show All

• Wee Bubba Does Replication Use Compression?

  Does SQL Server replication impliment any kind of compression It seems to me that this would be very helpful for congested WAN links and costly merge replication. There are also hardware compression solutions out there that will compress the data before it goes across the network. Hi Joshua, Here is a direct quote from book online http://msdn2.microsoft.com/en-us/library/ms151740.aspx Does replication work over low bandwidth connections Does it use compression Yes, replication does work over low bandwidth connections. For connections over TCP/IP, it uses the compression provided by the protocol but does not provide additional compression . For Web synchronization connections over HTT ...Show All