Answer Questions

• ylia How to delete/drop all the tables from SQL Server Database without using Enterprise Manager?

  How to delete/drop all the tables from SQL Server Database without using Enterprise Manager I tried using DROP Tables, Truncate Database, Delete and many more but it is not working. I want to delete all tables using Query Analyzer, i.e. through SQL Query. Please help me out in this concern. Nishith Shah Thanks man HI people I want to do this in MS Access database . Delete all tables . Is there a hidden SP here also or some other way . . Plz help Hay man what you are asking for,if you just check my reply, the answere is there ok, try this, this will delete/truncate all the Data from each table for in the database you connected EXEC sp_MSforeachtable @command1 ...Show All

• Evan Mulawski Deserialize xml data from sql 2005

  We're having a hard time with SQL 05's xml. In a nutshell, I have a schema. I have used .Net 2.0's xsd tool to create classes from this schema. This schema is also tied to a XML column in my database server. So far so good. However, when I go to deserialize the xml data stored in the database server I'm getting inconsistent results. Namely the differences in the following queries: SELECT LoanXML.query('declare namespace MISMO="http://mrgdev.local/mismo/";//MISMO:LOAN') FROM Loans WHERE Loans.InternalID = @LoanID returns something completely different from: SELECT LoanXML from Loans where InternalID = @LoanID The difference is that the first query throws xsi:nil=true into EVERY SINGLE NODE. Whereas the second one doesn't ...Show All

• project2n5e0o1 determin name of primary column

  given the name of any table how can i programmatically get the name of the primary key column You can use the INFORMATION_SCHEMA.TABLE_CONSTRAINTS view like: SELECT tc.CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS as tc WHERE tc.TABLE_SCHEMA = 'dbo' and tc.TABLE_NAME = '<your_table>' and tc.CONSTRAINT_TYPE = 'PRIMARY KEY'; ...Show All

• AlanKohl Universe Database (IBM) - Linked server no longer works with MS SQL 2005

  Has anyone managed to set up an IBM Universe database environment as a linked server to MS SQL 2005 If so please convey how you got it done. Thanks, Hi Isalih, I was wondering where you found an ODBC driver for Unidata I'm trying to get into a Unidata database via Access or SQL or whatever will work, but haven't been able to locate the appropriate ODBC driver. Thanks! Jeremy Unfortunately, we are using a RISC box and also the Windows version of the Universe product, so the examples above are of less use. Though you have confirmed for that we are using the correct approach. Thanks for the assist. - John ...Show All

• Chester R find all tables that a table is related to

  how can i find all the names of tables that a specific table is related to in tsql sp_depends Displays information about database object dependencies (for example, the views and procedures that depend on a table or view, and the tables and views that are depended on by the view or procedure). References to objects outside the current database are not reported. Examples This example lists the database objects that depend on the Customers table. USE Northwind EXEC sp_depends 'Customers' Assuming you have referential integrity in place you can also query the sys.sysforeignkeys view in 2005 or the sysforeignkeys table in 2000. Here is a query returning all table associations (2005 syntax ...Show All

• DRD32206 Hanging Indent

  This one is probably very simple, but I'm not sure. I am using SSRS 2005, and I already have a custom assembly being used in the report, but I'm hoping I won't have to use it for this. In a table, a list of company names is being returned in a single column. Some of them are pretty long, so they wrap to the next line. If this happens I would to indent the next line. So, it should look like the following: Company Name Company A Company B with a really long name Company C Anybody know an easy way to do this The only I can think of to meet this requirement is handling this programmatically, e.g. by checking the field value length and breaking the text if exceeds the required width with vbCrLf concatenated with some padding and the ...Show All

• aoky can we export olap cubes from sql server 2005 analysis service to sql server 2000 analysis service?

  Dear all, Thank you very much for your kind attention. Is it possible to export olap cubes from sql server 2005 analysis service to sql server 2000 analysis service And if it is possible, then how can it be done Really need help for this and thank you very much in advance for your help. I am looking forward to hearing from you. With best regards, Yours sincerely, Helen Hi, Chris, Thank you for your advice. With best regards, Yours sincerely, Helen No, it isn't possible to export cubes from AS2005 to AS2K. You'll have to rebuild them from scratch, I'm afraid. Regards, Chris ...Show All

• robertje Row height issue on export to Excel

  Hi all, I've been having some problems with a report on export to Excel. I have four tables, contained within a rectangle at the top of the report, followed by a second page of tables dynamically generated by the data being fed into the report. On export to Excel, the top sections of tables appear to export with a fixed row height that does not show all of the string contained within the cell. I've had similar issues before with "title" textboxes, but these are usually easily solved by expanding the height of the box within the report. In this case, this hasn't worked! Any idea Regards, Jon Hi Ian, The tables are positioned both horizontally and ver ...Show All

• Mr Dawson Unable to start T-SQL Debugging. Could not attach to SQL Server process on

  Please help! I cannot debug CLR procs remotely. Whenever I try to start debugging in VS2005 I get the error: Unable to start T-SQL Debugging. Could not attach to SQL Server process on .... I have clr enabled set to 1 and I have Allow SQL\CLR Debugging set on. But I continue to get this error. Any help would be greatly appreciated. Thanks! GN I have created the same user on both machines with the same password and remote debugging still does not work. Actually a firewall is not being run on either machine but I have also run msvsmon on both machines. Hi Richard, I created the same local user name on both machine, like <machinename>\<username> wit ...Show All

• eman1975 Generate SQL for a table

  Hi I have two questions i) is there any SP which will generates SQL Script for a table including all constarint(PK,FK), index etc. and the table data in the format of "INSERT INTO" . if NO, how can i create to do so, or any other SP which will help me( may be third party one) ii) Where had "Scptxfr.exe" gone in SQL Server 2005 Regards, Thanks. Gurpreet S. Gill There is no SP. You will have to create one yourself or use SMO for example. I don't know the answer to the 2nd one. I am moving the thread to Tools forum to see if someone there might know.   Gurpreet Singh Gill wrote: Hi I have two questions i) is there any SP which will generates SQL Script for a ta ...Show All

• mathieu.szablowski Linked Server B/w two SQL SERVER 05 instances (on differnt pc;s) VERY URGENT

  I created a linked server named CONFUSION (as the machine name with perticular IP say a.b.c.d) TESTED the connection by USE master GO EXEC sp_configure 'show advanced options', 1 GO RECONFIGURE WITH OVERRIDE GO EXEC sp_configure 'xp_cmdshell', 1 GO RECONFIGURE WITH OVERRIDE GO EXEC sp_configure 'show advanced options', 0 GO CREATE TABLE #foo ( pingResult SYSNAME NULL ); INSERT #foo EXEC master..xp_cmdshell 'ping CONFUSION'; IF EXISTS ( SELECT 1 FROM #foo WHERE pingResult LIKE '%TTL%' ) BEGIN PRINT 'Feel free to use linked server.'; END ELSE BEGIN PRINT 'Linked server not available.'; END DROP TABLE #foo; I executed the above code and the result was ::: (13 row(s) affected) Feel ...Show All

• programmer01 High Availability and Scalability ...

  We have a multi-lingual website (English, Spanish and German). We have a table called Posts that is potentially getting really big. We are in the initial design phase of the database and would like to know what the experts are suggesting to keep our database mean and lean in the long run. We have been talking about splitting the database up into 3 separate databases, one for English, one for Spanish and one for German. The language specific databases would also be hosted in countries where the language is spoken eg. the German database would be hosted in Germany. Or maybe database partitioning by language Making changes to 3 databases once launched seems like a nightmare. It would be nice to have one main ...Show All

• ykgreene ClusterDistance value

  Can somebody please define the result of the ClusterDistance() function for me.  BOL and MSDN are vague about what the output means and I am getting some cases that have a value of zero and sometimes there are more than one per cluster.  Thanks in advance, Dan Meyers That's ok - it's an issue if you get more than one cluster per case with a ClusterDistance() of 0. Imagine if you have two identical cases - it would make sense that they have the same ClusterDistance(), would it not It does make sense. I just wanted to make sure that I was understanding everything correctly and I was not sure because the documentation is a bit vague in its definition of the function. Thanks Jamie. I believe the cluster ...Show All

• R1ZWAN is there a collection of all database objects

  i want to write a tool to make scripting of databases easy. the user will select the server and dababase, then they will select what they want to script: eg tables, sprocs, permissions, scheemas etc etc. currently i have a load of check boxes , one for each type of object in the db ( one for tables, one for sprocs etc). this is very long winded,and if there was a collection of the db objects i could call into a list box it would be a lot tidier and easier. There are a number of collections within the Database object in SMO which you can use, such as Tables, Triggers, StoredProcedures, Users and Views. Each of these is a collection of the named objects within the database. (At the Server level of course, t ...Show All

• david2929 Package configurations stored in the database

  If the configurations are stored in the database then does the package pick up the configuration as and when required or it a one time pick when the package is executed. What I plan to do When the package is executed, I want to have a script task at the start of the package that will update the configuration table in the database with the values that the package needs to run with. I mean change the values of the configurations of the tasks which will be executed after the script task. Thanks for your time. $wapnil A simple way may be to have a master package with a ForEach loop container and an Execute package task inside. The ForEach loop would iterate through the row ...Show All