Does Watch Variables Work In Std Edition?
Mar 2, 2008
between my wrox book, google and looking everywhere in BIDS, I couldn't figure out how to watch the variables being set in an Exec SQL Task control flow item. My wrox book said something about right clicking the var in the script (I wasnt in a script), or using the debug menu or pressing ctrl-alt-q. None of this worked. Is it possible that at installation a certain choice wasnt made, or maybe watch windows only work in the context of something other than the control flow?
View 9 Replies
ADVERTISEMENT
Feb 5, 2008
Not sure if this is a "user training" issue or a bug, I seem to have difficulty dragging and dropping variable(s) to the watch window. Is there a specific sequence I need to follow to enable this feature in BIDS? Appreciate any feedback.
View 5 Replies
View Related
Sep 27, 2007
I am attempting to use the SQL Server 2008 Developer Edition (Management Studio) to create/manage a Compact Edition 3.5 database. My problem is that I cannot even create/open the compact database in Management Studio. Any help would be GREATLY appreciated. TIA
Problem Creating the Compact Database:
Open 2008 Management Studio
From menu choose File | Connect Object Explorer...
Choose SQL Server Compact Edition as the Server type.
Choose <New Database...> as the Database file.
Browse to folder where file will be created (C:MyDatabase#1.sdf was used in my example)
Leave all other field as default selections OR make changes, either way it does not work.
Click OK.
At this point the OK button just becomes disabled and nothing happens.
Problem Opening An Existing Compact Database:
Open 2008 Management Studio
From menu choose File | Connect Object Explorer...
Choose SQL Server Compact Edition as the Server type.
Choose <Browse for more...> as the Database file and locate a ".sdf" file that I created using VS2008.
Enter password, if any.
Click OK.
The following exception is displayed:
TITLE: Connect to Server
------------------------------
Cannot connect to C:Documents and SettingsdarrinbMy DocumentsVisual Studio 2008ProjectsTestSQLCompactEdition35TestSQLCompactEdition35AFS.sdf.
------------------------------
ADDITIONAL INFORMATION: Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
Could not load file or assembly 'Microsoft.SqlServerCe.Enumerator, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) (mscorlib)
------------------------------
BUTTONS: OK
------------------------------
View 1 Replies
View Related
Dec 12, 2006
After a couple hours of searching, I'm no closer to figuring this out than I was when I started. So...
I have a foreach loop. It has a collection of numbers of type Double, but I've used int32, int64, etc. trying to get it to work. int32 would be ideal. This is mapped to User::accounts.
Inside the loop is an Execute SQL task. All I want to do is the equivalent of "select @[User::accounts]", to be replaced in the future with an update query. That particular string doesn't work.
I've mapped the variable to a parameter of type FLOAT and tried "select @accounts". That doesn't work.
Do I need to declare something? Not use parameters? Neither the documentation nor the error messages (I got an "precision is invalid" error... once) has not been clear on this. I know once I figure out how it works, things will get better.
Thanks in advance.
View 1 Replies
View Related
Oct 26, 1999
I am writing a procedure to drop a specific user's schema only. I select all his/her table name and foreign key in a temp table first and then use a cursor to get the table name and foreign key, and begin drop foreign keys and drop table. However, sql think it is wrong with the syntax like "alter @table_name". Does anyone have a clue, what is wrong with my syntax. Or someone know how to drop one specific user's schema only (Other user may have same table in the database, and you don't want to drop that.
Attached is my scripts: please correct it. Thanks.
CREATE procedure sp_drop_schema @user sysname
as
select o.name table_names, o.id table_id, s.parent_obj Key_id, s.name key_name, u.name users_name
into #temp1
from sysobjects o inner
join sysobjects s on o.id=s.parent_obj
join sysusers u on o.uid=u.uid
where s.type='f' and u.name=@user
declare cur_f cursor
for select table_names, key_name
declare @table_name varchar (80), @key_name varchar (80)
open cur_f
fetch next from cur_f into @table_name, @key_name
while @@fetch_status=0 begin
alter table @table_name
drop constraint @key_name
fetch next from cur_f into @table_name, @key_name
end
close cur_f
deallocate cur_f
drop table #temp1
select o.name table_name, o.id table_id, o.uid users_id, u.name users_name
into #temp2
from sysobjects o
inner join sysusers u on o.uid=u.uid
where type='u' and u.name=@user
declare cur_temp cursor
for
select table_name
from #temp2
declare @tab_name varchar (80)
open cur_temp
fetch next from cur_temp into @tab_name
while @@fetch_status=0 begin
drop table @tab_name
fetch next from cur_temp into @tab_name
end
close cur_temp
deallocate cur_temp
drop table #temp2
View 1 Replies
View Related
Jul 23, 2005
Microsoft site says yesIf yes, then if I publish my site on a win2k server, will it stillwork?These questions assume that a yes answer does not involve jumpingthrough too many hoops or having to spend an entire day or longerporing through MSDN.God I sound jaundiced don’t I!Any help with these questions will be greatly appreciated.Thanks,Adso--Posted using the http://www.dbforumz.com interface, at author's requestArticles individually checked for conformance to usenet standardsTopic URL: http://www.dbforumz.com/General-Dis...pict221847.htmlVisit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=763479Posted Via Usenet.com Premium Usenet Newsgroup Services----------------------------------------------------------** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **----------------------------------------------------------http://www.usenet.com
View 2 Replies
View Related
Mar 14, 2007
I have a Symbol MK1200 device (Intel XScale processor) running CE.NET 4.2 and when I try
to reference any SQL objects I get the error:
Can't find PInvoke DLL 'sqlceme30.dll'
The documentation says that Compact Edition is supported on CE.NET 4.2,
(ms-help://MS.SSCE.v31.EN/ssmmain3/html/ee220634-55c9-4123-85c4-4e6ceb07f942.htm)
but I came across a hotfix (http://support.microsoft.com/kb/924811/) which
contradicts this and says CE.NET 4.2 is not supported by default.
Can someone clarify this for me? I know that VS.NET 2005 doesn't support debugging of CF 2.0
apps to CE.NET 4.2 devices but I thought I could manully deploy a CF 2.0 SP1 application with SQL
Compact Edition (although I'm still not sure whether I need the hotfix) ?
Either way I've been playing around and here is what I found ...
1. I installed CF 2.0 SP1 and verified a simple 'Hello World' application could deploy. All worked ok.
2. I downloaded & installed the SQL Compact Edition CABs on the device manually from
'SmartDevicesSDKSQL ServerMobilev3.0wce400armv4'.
I opened Query Analyzer on the device and it worked i.e. I could open a database, run query, etc.
3. I modified my application with the following sample code:
try
{
SqlCeCommand sqlCmd = new SqlCeCommand();
}
catch (Exception exception)
{
MessageBox.Show(exception.ToString());
}
Once again, just deploying (not debugging) the app. and got the error above 'Can't find PInvoke DLL 'sqlceme30.dll'
4. I installled the HotFix from http://support.microsoft.com/kb/924811/, now Query Anaylzer did not work even though it did work pre-hotfix install, and I'm still getting the same error when I test my code.
Can anyone shed any light on this? It's driving me up the wall ;o)
View 6 Replies
View Related
Feb 28, 2006
Hi all,
I am new to SQL server. I just installed SQL Server 2005 enterprise edition .
I have not more experience in SQL but I need some tutorial about how to use SQL Server 2005 and create tables and make queries and relate tables . I can't find any exact location in Microsoft website about SQL Server enterprise edition and documentation where i can find beginner's resources. which feature we use for creating the tables and other features for making the database.
Can anyone please give me the location.
Thanks
View 1 Replies
View Related
Feb 28, 2006
Hi all,
I am new to SQL server. I just installed SQL Server 2005 enterprise edition .
I have not more experience in SQL but I need some tutorial about how to use SQL Server 2005 and create tables and make queries and relate tables . I can't find any exact location in Microsoft website about SQL Server enterprise edition and documentation where i can find beginner's resources. which feature we use for creating the tables and other features for making the database.
Can anyone please give me the location.
Thanks
View 1 Replies
View Related
Jan 24, 2008
Hi there,
i've tried using the SELECT SQL sentence on PPC with UNION and INNER JOIN in combination with DATEDIFF function which works fine on ordinary SQL but obviously does not work on compact edition. Is there some workaround?
SQL sentence that works:
Code Snippet
SELECT * FROM
(
SELECT 'O' Type, O.Name , OC.Name Contact, Birthday FROM OutletContact OC
INNER JOIN Outlet O ON OC.OutletID=O.OutletID
UNION
SELECT 'W' Type, W.Name,WC.Name Contact, Birthday FROM WholesalerContact WC
INNER JOIN Wholesaler W ON W.WholesalerID=WC.WholesalerID
) S
WHERE Birthday IS NOT NULL AND (DATEDIFF(day,GETDATE(),Birthday) BETWEEN 0 AND 14)
Thanks for any hint or solution to my problem,
Gorazd
View 1 Replies
View Related
Mar 3, 2006
We are new to SQL Server 2005 Express Edition. We are going to develope a solution for one of our client and we have to decide on which database to use for the solution. Client wanted to have a low cost solution. Thus we were not in a position to push them for SQL Sever 2000.
In the process, we also thought of having MySQL as one of the option. Another option we have is to use SQL Server 2005 Express Edition.
We wanted to know if SQL Server 2005 Express Edition can be used with Visual Studion 2003 (Ver 1.1) or it can only be used with Visual Studio 2005 (Ver 2.0)?
Hope to get feedback soon.
Regards
Sanjeev
View 1 Replies
View Related
Feb 25, 2006
I have encountered an error (as shown below) when attempting to install the SQL Server 2005 Express Edition 9.00.1399.06 on on my XP SP2 pc.
the file: "C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSummary.txt"
show the following messages:
Machine : DUMBO
Product : SQL Server Database Services
Error : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
and ...
Machine : DUMBO
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.00.1399.06
Install : Failed
Log File : C:ProgrammiMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_DELL8400_SQL.log
Last Action : InstallFinalize
Error String : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (17058) .
Error Number : 29503
Also, the file: "C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_CBXP_Core.log"
show this message:
Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run:
"c:ProgrammiMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 17058
Aborting queue processing as nested installer has completed
Message pump returning: 17058
Maybe that's not a fatal error, but the SQLExpress service does not get installed.
Someone can help me?
Thanks!
View 9 Replies
View Related
Feb 27, 2007
hi frnds,
i want to view the runtime variable value in the watch window while the package is running,
how i will get that watch window. i searched all the menus but i didnt get it.
im using Microsoft Visual Studio 2005 for SSIS package.
View 1 Replies
View Related
Mar 26, 2007
I honestly don't see where to view the watch window. Can someone please advise.
Thanks
View 5 Replies
View Related
Feb 15, 2006
All,
I cannot use the watch window while debugging. I want to use it to look at the runtime variable values. The watch window is blank when I click on it, could someone please tell me where and how to configure it?
Many thanks
View 1 Replies
View Related
Aug 17, 2006
I need an example of a WQL query to use in the WMI Event Watcher task to watch for the presence of a file. The task has to succeed for either:
1) The file already exists when the task is run
2) The file shows up while the task is running (waiting)
Also the query has to reference a UNC path and file name. The file I'm looking for is just a flag file telling me a table is refreshed in our Data Warehouse.
I also need pointers on how to set the WMI connection manager. For the server, do I use the \servername of the fileserver? Do I need to include the folder the files are in (eg. \servernameflags)?
Thanks!
Kory
View 4 Replies
View Related
Jan 12, 2006
Is there a way i can see the value of the variables during debugging ?
View 10 Replies
View Related
Jan 30, 2008
I have a folder that gets 2 to 3 files dropped everyday. I want to create a package that loads only the new files into the database. The old files (Processed files) remain in the same folder and cannot be moved. How do i accomplish this in ssis?
I found something about the file watcher task with the for loop, but just can't put it all together.
Any help would be appreciated.
Thanks
View 6 Replies
View Related
Aug 19, 2007
Hi Guys,
I've got an order generation query that will _sometimes_ run long. By that I mean every few days a query used to estimate the required stock quantities for an order will time-out because it has taken an extended time to run. This only occurs at one particular site. This site shares a common schema with others who do not experience this issue, although site is a particularly busy one.
This query (a stored proc call) needs to aggregate sales data from ~200k rows and usually takes 10-15 seconds. On the days when it 'runs long' it will hit the 5 minute time-out period and be failed by the application.
The problem I have with this process is that if I have the application dump out the query it's using to generate the order (this query will vary as the stored proc is passed the name of a temp table to use for this order) so I can run it in Query Analyzer to get an execution plan and maybe some clue as to why it takes so long; the issue will vanish. After I've tried to investigate in this way an order generated from either Query Analyzer or the application will work in the normal time. When the query is running long any processes which attempts to write to the sales data tables will get blocked until the order generation has finished.
The application is accessing the database via ADO 2.6. The database itself is running on SQL Server 2000 sp3 under Win2k.
I believe that the SQL Profiler is the tool best suited to investigate this but I'm hoping for some advice on which of the myriad of watchable metrics I should be checking here.
Any profiler advice or estimates as to what the issue may be here would be great!
-Karl.
View 1 Replies
View Related
Mar 15, 2007
hi frnds,
i have one SSIS package with single SQL Execute task.
select empname from emp
This is the query i had mentioned in that SQL task.
i had created the varibale User:rs as object and i mapped that to the resutset and i selected fullresultset in general tab.
In the debugging mode im getting the com object as the result of that variable.
This is the o/p which i got in the debugging mode.
- User::rs {System.__ComObject} __ComObject
Type __ComObject
Value System.__ComObject
but i requires the empname to be displayed in that mode.
how to get that?
pls tell me .
View 4 Replies
View Related
Jan 25, 2006
When i debug a trigger is it possible to add a WATCHon the INSERTED or DELETED?I think not, at least I couldn't figure out a way to do so.Does someone have a suggestion on how I can see the values?I did try to do something likeINSERT INTO TABLE1(NAME)SELECT NAME FROM INSERTEDbut this didn't work. When the trigger completed and Iwent to see the TABLE1, there were no records in it.Are there any documents, web links that describe waysof debugging the trigger's INSERTED and DELETED?Thank you
View 11 Replies
View Related
Mar 21, 2007
Can't an SSIS package run "in the background", so to speak, without having either the cmd.exe or dtexecui windows open while executing? I'd obviously rather not have to have a window open when the thing is running right?
View 2 Replies
View Related
Sep 4, 2006
Hi,
I am not comfortable with DTS 2000 but I need to execute a encapsulated DTS 2000 package from a SSIS package. The real problem is when I need to pass SSIS variables to DTS 2000 package. The DTS 2000 package have 3 global variables that I can identify on " Execute DTS 2000 Package Task Editor - Inner Variables ". I believe the SSIS variables must be mapped on " Execute DTS 2000 Package Task Editor - OuterVariables ". How can I associate the SSIS variables(OuterVariables ) to "Inner Variables"? How can I do it? Much Thanks.
João
View 8 Replies
View Related
Jan 24, 2006
Hi,
I would like to design a SSIS package, which have couple of variables. It loads a xls file specified in a variable [varExcelFileFullPath] .
I will run it by commands: exec xp_cmdshell 'dtexec /SQL ....' (pls see an example below).
It seems it does not get the values passed in for those variables. I deployed the package to a sql server.
are there any grammar errors here? I copied it from dtexecui. It worked inside Dtexecui not in dos command.
exec xp_cmdshell 'dtexec /SQL "LoadExcelDB" /SERVER test /USER *** /PASSWORD ****
/MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EW
/LOGGER "{6AA833A1-E4B2-4431-831B-DE695049DC61}";"Test.SuperBowl"
/Set Package.Variables[User::varExcelFileName].Properties[Value];"TestAdHocLayer"
/Set Package.Variables[User::varExcelWorkbookName].Value;"Sheet1$"
/Set Package.Variables[User::varExcelFileFullPath].Value;"D: estshareTestAdHocLayer.xls"
/Set Package.Variables[User::varDestinationTableName].Value;"FeaturesTmp"
/Set Package.Variables[User::varPreSQLAction].Value;"delete from FeaturesTmp"
'
thanks,
Guangming
View 2 Replies
View Related
Jan 22, 2008
Hi
-I have istalled sql server 2005 standard edition , I want to install sql server 2005 enterprise edition on the same machine.
Is it possible? I have Microsoft windows server 2003 SP2 and 1GB RAM.
I want to use partition function with the enterprise edition, will the trial version of sql server work for me?
-If I have already created a database and tables using the standard edition, will I be able to access and use the database using the installed trial version or will I have to start a fresh creating a new database?
- Is it possible to access the same database with any of the installed versions?
BTW, I am prety new to sql server and databases , I am trying to learn by myself
Thanks
View 9 Replies
View Related
Sep 23, 2006
Hello!M a newbie.. I just want to know, that wots the difference b/w SQL Server Standard Edition and Express Edition.?And can I use Visual Studio 2005 (Professional Edition) with SQL Server Express Edition.?
View 1 Replies
View Related
Dec 15, 2006
Dear All,We have a database which contains many tables which have millions ofrecords. When We attach the database with MS SQL Server 2005 StandardEdition Server and run some queries (having joins, filters etc.) thenthey take very long time to execute while when We execute same querieson Enterprise Edition then they run 10 times faster than on standardedition.Our database does not use any features which are present in EnterpriseEdition and not present in Standard Edition. We want to know what arethe differences between Standard Edition and Enterprise Edition forperformance. Why should we go for Enterprise Edition when StandardEdition has all the features required.We are presently using evaluation versions of SQL Server 2005 Standardand Enterprise Editions.Thanks and regards,Nishant Sainihttp://www.simplyjava.com
View 23 Replies
View Related
Mar 17, 2007
Hi i have two version of SQL server express (with Visual Studio 2005) and developer edition i am trying to access an sql database file -created by the express edition integrated with Visual studio- using a developer edition instance can i just attach it and access it. and can i use BI and reporting services on that file
View 1 Replies
View Related
Apr 10, 2008
I am attempting to upgrade a 2005 Standard Edtion to Enterprise Edition. This is a default instance. All components are upgraded successfully except the Database Engine. I receive the following error:
SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]The certificate cannot be dropped because one or more entities are either signed or encrypted using it.. To continue, correct the problem, and then run SQL Server Setup again.
This installation does not have encryption enabled, so I do not undersand the error or how to correct it.
After rebooting the SQL instance appears to be upgraded to Enterprise, but it cannot be upgraded to SP2.
Thanks,
View 3 Replies
View Related
Oct 17, 2007
Hi all--I'm researching the cleanest downgrade path from a trial edition of SQL Server 2005 Enterprise to a licensed Standard Edition copy. It looks like downgrading will entail uninstalling the old version and installing the new version, but I'd like to save the original setup as much as possible. Detaching the old databases will preserve the non-system databases; what method would work best for restoring the system databases?
Thanks!
- Jon
View 1 Replies
View Related
Feb 6, 2008
The enterprise edition of SQL server includes some advanced BI features, for example the fuzzy lookup feature of IS. If the IS package lives on an enterprise edition of SQL server and the database the package it is targeting lives on a standard edition of SQL server can the advanced features be used? Can you run a fuzzy look against a database on a standard edition of SQL server when th IS package lives on an enterprise edition of SQL server? THANKS!
View 1 Replies
View Related
Jan 28, 2008
Hi,
I have recently upgraded a SQL x64 server from Developer Edition to Standard Edition, This succeeded without issue. Following a reboot SQL Server yielded the following message
Your SQL Server installation is either corrupt or has been tampered with unable to load SQLBoot.DLL. Please uninstall then re-run setup to correct this issue.
Please can anyone help ?
Many Thanks
Marcus Stuart
View 1 Replies
View Related
Jun 2, 2015
I have just migrated a complete SQL Server 2008 R2 SP2 development server from Windows 2003 to Windows 2008 Server. Â I just realized that I should not have used the Data center edition Product Key as this is Development server. Â I am being asked to downgrade to Developer edition. Â I have already migrated all the logins, databases(40 databases), cubes etc. Â I really can't uninstall and reinstall Developer edition. Â How else can I upgrade/downgrade to switch from Datacenter edition to Developer edition. Â
View 2 Replies
View Related
