The following dynamic query returns a list of tables some of which do not have records in them. Can someone help me out, I am trying to exclude the tables with no records returned? Also, I want to exclude tables where there is not a rn_create_user or rn_edit_user defined in the table?
DECLARE @TableName sysname, @Sql varchar(8000)
SELECT @TableName=MIN(TABLE_NAME) FROM INFORMATION_SCHEMA.TABLES
WHILE @TableName IS NOT NULL BEGIN SELECT @Sql='select o.* from ' + @TableName + ' o where not exists(select * from users u where (u.users_id = o.rn_create_user) or (u.users_id = o.rn_edit_user) )'
EXEC (@Sql)
SELECT @TableName=MIN(TABLE_NAME) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME>@TableName
Dear ReaderI am trying to design a database. How can I make best Judgement that Indexing (which I am trying to fix during Diagram Desingning process)is ok.I am able to identify the best candidate for the indexing.Below is the details I want to understand:AreaZIPCityCountyDistrictState/ProvinceCountryNow I want the data retrival optimization through Index. (you can suggest another idea, also)Entities Area,...., Country have independent tables.Example:Area_TableAreaID (PK)AreaThey have relationship- one to many- if you go from Country to Area.There is one more table:Location_Table (PK)LocationIDAreaIDZIPIDCityIDCountyIDDistrictIDState/ProvinceIDCountryID(Location_ID is further related to the Address of the contact.)GUI has a single form to enter these details.On a save command details in all the tables -Area to Country- (individually) being inserted.& simultaniously Location_Table is also being inserted with the details.Following is the situation of being queried these tables:(1) GUI user can select an Area than the related details of ZIP .., ..., ...upto Country etc. should be loaded automatically (id it is previously stored by the user entry in the database.)(2) Contacts have to be retrived on the basis of Area, ZIP, .....County. (Necessary Groupings are required )Example:If Contacts are queried Country Wise then the Display should beCountry1State1District1County1City1ZIP1Area1Area2ZIP2City2County2District2Country2Please Guide.SuryaPrakash****************************************** This message was posted via http://www.sqlmonster.com** Report spam or abuse by clicking the following URL:* http://www.sqlmonster.com/Uwe/Abuse...0255a1765491f15*****************************************
I looked around the Microsoft web sites but could not find anything on how to submit an enhancement request for Microsoft Reporting Services. I would like to request the ability to prevent exporting of a report without having to disable exports for all reports on the reporting server. In other words I would like certain reports to be exportable but others not.
I have sql server 2005 express and toolkits installed. However, I only see Report Server projects in my Visual Studio 2005 when I choose a Business Intelligence project.
Will someone please help me download the right file to start using SSIS designer?
I have a script which grabs data from a source server. The problem is I have over 50 source servers, so I have to make a script for each one.. EXACTLY the same code but different linked server address.
So I was wondering if i can put the server name into a variable so I only need to make one script. Is that possible?
When I drop a new component onto the design surface, it appears with dotted lines around it, as it is selected.
But, the F2 key (the hotkey for rename) does not work.
I have to click on some other component, and then back on the new component, and then the F2 key works.
I remember reporting this bug back in the beta cycle, but it is still present even in the release -- I actually think Ã?'m using the SP1 version of 2005, but see version info below to be sure:
Remote terminal services broke my copy buffer again, as is so often does, so pasting in the version info failed -- falling back to manual typing -- SSIS 9.00.2047.00.
I am executing a single package that references 180 other packages , after executing the first 90-100 packages , SSIS designer completely freezes and then i have to kill the session using Task Manager . Is this a limitation of SSIS or is it a system constraint ?
If you have any suggestions or workarounds for de same plz do reply
When I installed SP1 on my SQL Server 2005, the performance of the package designer dropped enormously. I have to wait like 30 seconds after I drag-and-drop a datasource from the toolbox to the design area. Also it takes a very long time to run the very simple package. Not to mention opening some complicated package that was done before applying SP1. The package scheduled in SQL Agent went from 3-4min to 5-6min.
Can anyone address this issue? Maybe there's something I did wrong?
While installing SP1 I ecountered strange behaviour (some messages about file locking, rebooting and stuff), but in the end it said that it was successful
Our Visual Studio installation suddenly starting producing the error below upon trying to open any .dtsx package; although by "suddenly" I'm sure it was due to some Windows update or other program install, update, or uninstall. I've spent two days uninstalling, reinstalling, and repairing everything that is seemingly related to VS, but no luck. I've searched the forums and could not find this specific error mentioned, although I have tried some of the suggestions to fix possibly related 'class not registered' errors, but again no luck.
=================================== There was an error displaying the layout. (Microsoft Visual Studio) ------------------------------ For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.762&EvtSrc=Microsoft.DataTransformationServices.Design.SR&EvtID=DDSErrorDeserializeDiagram&LinkId=20476 =================================== Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)) (msddsp) ------------------------------ Program Location: at MSDDS.IDdsDiagram.CreateShape(String ProgID, Boolean Visible, Int32 X, Int32 Y) at Microsoft.DataWarehouse.Controls.Interop.AxMSDDS.CreateShape(String progID, Boolean visible, Int32 x, Int32 y) at Microsoft.DataWarehouse.Design.ComponentDiagram.OnCreateShape(Object logicalObject, Int32 x, Int32 y, Boolean visible) at Microsoft.DataTransformationServices.Design.DtsComponentDiagram.OnCreateShape(Object component, Int32 x, Int32 y, Boolean visible) at Microsoft.DataWarehouse.Design.ComponentDiagram.CreateShape(Object logicalObject, Int32 x, Int32 y) at Microsoft.DataTransformationServices.Design.DtrControlFlowDiagram.CreateExecutableShape(DtsContainer dtsContainer, Int32 x, Int32 y, Int32 width, Int32 height) at Microsoft.DataTransformationServices.Design.DtrControlFlowDiagram.RefreshSequenceExecutables(IDTSSequence sequence) at Microsoft.DataTransformationServices.Design.DtrControlFlowDiagram.AfterDeserialize()
If you try to "enable memory restriction" from the Lookup component GUI you need to input both 32 and 64 bit size of maximum memory. However when clicking "OK" on the editor you get a message like :
TITLE: Microsoft Visual Studio ------------------------------
Error at Update Execution Logs [Lookup folder path 1 [4429]]: Failed to set property "MaxMemoryUsage64" on "component "Lookup folder path 1" (4429)".
Hello everybody! I've already posted this question before but this error never been resolved. My DTS designer is totally screwed. When trying to create new local package getting error message "Could not create Component Categories Manager". I can't even use DTS to copy data in using DTS wizard. Somebody recommended to reinstall SQL Server which I did but it didn't solve my problem.
Does any one know of a way that a group of my developers can use this without giving them access to the rest of Enterprise manager?
Want to give them access to write queries and they are all Access developers so that I have to do as little training as possible then letting them have Query designer would keep them in their nice little world without hassing me to much.
When using Enterprise Mgr on a workstation connected to a MSSQL Server, if I attempt to start a new DTS Package, I get the following msg: Title: DTS Designer Error Text : Could not create Component Categories Manager
I get the same msg when trying to edit an existing package. I tried to re-register Dtspkg.dll,Dtsui.dll, and dtsffile.dll. All were successful but Dtspkg.dll, which failed. Does anyone know what causes this, and what else I can try?
When i'm trying to open the table say return all rows in Enterprize manger it gives me an error saying Query Designer encountered a query error Unspecified Error. I could not figure out what's goin on...
I appriciate if any one can help me out solving with this problem.
I'm fairly new to Proclarity and I'm using 6.3. I just have desktop professional and we still don't have proclarity analytical server installed yet. I would like to work around with KPI Designer, how am I able to install it. Does it come with extra components and needs to be installed from the installation CD?
...Also folks any good resources in learning proclariy?
Can you turn on a grid in the designer to assist you with aligning tasks, etc. I've trie all kinds of things, but can't get a grid. Or even maybe rules? I'm probably missing something real simple, but can't find.
I use the Report Wizard to generate reports. Within the "Design the Query" screen, I try the query statement as : exec mydb.dbo.rptSales @fortheyear It shows me an error: Implicit conversion from data type sql_variant to smallint is not allowed. Use the CONVERT function to run this query.
The stored procedure of rptSales is CREATE PROCEDURE dbo.rptSales @pyear smallint=null AS .......
The rptSales has been tested OK on SQL Server Management Studio.
Actually, I have other similiar stored procedures using smallint as a parameter, and I can use the Report Wizard to generate reports, except the above one.
I have dragged 3 SqlDataSource Controls to the WebDesigner and none are appearing graphically in the Designer View, but they are in the Source View. How can I get the control to appear in the designer.
Hello! Yesterday my DTS designer was fine and today suddenly when I open the package in designer there is nothing there. I tried to create new package and it gave me an error when I was trying to save it "It is insufficient disk space to complete operation".
I am testing SQL Server 2000 and after having installed it on a machine with SQL 7 already on it everything went OK.
However, if I try to create a DTS package (or open and existing one) on either of my SQL Server instances I get a "DTS Designer Error". After which, the DTS package window opens but I can't see any of the tasks in the tool bar. I can't select any tasks from the Task option in the menu bar either.
Has anyone experienced anything similar? Any suggestions would be appreciated.
I am testing SQL Server 2000 and after having installed it on a machine with SQL 7 already on it everything went OK.
However, if I try to create a DTS package (or open and existing one) on either of my SQL Server instances I get a "DTS Designer Error". After which, the DTS package window opens but I can't see any of the tasks in the tool bar. I can't select any tasks from the Task option in the menu bar either.
Has anyone experienced anything similar? Any suggestions would be appreciated.
I've got SQL Server 7.0 SP1 installed (in a NT4 SP6 environment).
Recently, it came up with error whenever I try to open a table or a view (return all rows) inside the Enterprise Manager. The descriptive (NOT!) error message is like this:
"The query cannot be executed because some files are either missing or not registered", and on pressing "help", the help files report "Query Designer cannot locate your query files and cannot run your query"
I have tried re-booting the machine and upgrading mmc.exe to version 1.2 (from 1.1), but both in vain.
Checked out BOL on this issue, but not enough info received to troubleshoot. Hoping someone out there has some input.
This issue is only happening on the server side not the client. Also, it suddenly appeared on three different machines.
Query Designer: "An unexpected error happened during this operation" [Query} - Query Designer encountered a Query error: Unspecified error.
The how: In a database, go to tables and select a table known to have data right click on mouse and select Open Table, return all rows. This is when the error appears.
BOL states the the file may be corrupt or from a non-supported version of SQL Server EM. Nothing was installed on these servers and we're still on SP2. This error just all of a sudden appeared and spread to 3 different machines...
Another issue is the Return to Top function is disabled. This function provides the maximum number of rows to fetch.
