|
Is it possible to run an SSIS package created by SQL 2008 Business Intelligence Studio in a SQL 2005 environment? I'd rather not have to install SQL 2005 / VS 2005 in my development environment.
Started by Richard Szalay on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
This talks a little more about VSTA here.
SQL Server Sql Server 2005 uses VSA(Visual Studio for Applications).
Yes it is possible - I run 2008 developed dtsx packages all the time on our 2005 box.
|
|
I have a SQL script that creates a package with a comment containing an ampersand (&). When I run the script from SQL Plus, I am prompted to enter a substitute value for the string starting with &. How do I disable this feature so that SQL Plus ignores...
Started by JoshL on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Here is the URL for the faq: http://www.orafaq.com/wiki/SQL *Plus_FAQ#How_does_one.
To work for me.
|
|
I use RedGate SQL data compare and generate a .sql file so i can run it on my local machine but the problem is the file is over 300mb and i can't do copy and paste because the clipboard won't able to handle it and when i try to open the file in sql management...
Started by Jack on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
Is quite similar to this one
You can save your file/script as .txt or .sql and run it from Sql ServerRun it at the command line with osql, see here:
http://metrix.fcny.org/wiki/display/dev/How+to+execute+a+.SQL+script+using....
|
Ask your Facebook Friends
|
SQL Express is installed on the machines that I'm going to, but I'm not going to install the clunky SQL Management Studio. I just want an EXE I can run, so preferably I'd like it to be install-less.
Current options are:
1) Write one myself - not too hard...
Answer Snippets (Read the full thread at stackoverflow):
It is an SQL GUI and comes with an installer-less version.
Thanks
Try RazorSQL.
I found a good db admin tool.
Please see SO answers: SQL Server Management Studio Alternatives
There most certainly is.
|
|
I'd like if its possible to work out from inside sql server how long sql server has been running.
Would like to use this in conjunction with one of the DMV's for unused indexes, but the couters are re-set every time sql server loads, so I'd like to know...
Started by Nick Kavadias on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
)*60 PRINT 'SQL Server "' + CONVERT(VARCHAR(20),SERVERPROPERTY('SERVERNAME'))+'" is Online for the past program_name = N'SQLAgent - Generic Refresher') BEGIN PRINT 'SQL Server is running but SQL Server Agent <<NOT>....
|
|
When the SQL Server (2000/2005/2008) is running sluggish, what is the first command that you run to see where the problem is?
The purpose of this question is that, when all the answer is compiled, other users can benefit by running your command of choice...
Started by Sung Meister on
, 9 posts
by 9 people.
Answer Snippets (Read the full thread at stackoverflow):
I use queries like those:
Number of open/active connections in ms sql server 2005
sp_who_3, blocks, what it's currently doing, the T/SQL it's running, and the statement within the T/SQL that is currently ....
If necessary.
|
|
Is there any way for a DBA to peek in on the execution plan of a long-running query in SQL Server 2000? I know how to get the SQL being run using fn_get_sql(). And yes, theoretically if open a new connection and set the environment flags the same, it ...
Started by entaroadun on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Maybe....
You can then run this in query analyzer and get an execution plan.
The best you can do is run DBCC INPUTBUFFER on query process and see what the last statement being executed was.
No you cannot.
And get the estimated execution plan.
|
|
The title pretty much says it all - if you schedule a SQL Server job to run every X number of minutes, and it does not finish the previous call before the # of minutes is up, will it skip the run since it is already running, or will it run two instances...
Started by Sam Schutte on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
The SQL Server agent checks whether the job a job that's already....
I'm pretty sure it will skip it if it is running.
When running such a test in SQL Server 2005 it skipped the run that was overlapped.
The WAITFOR DELAY).
|
|
What is Minimum Windows Server licence to run a SQL server for use in a web farm. Can I run a SQL on a Server2008 Web edition?
Started by Gargamel on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at serverfault):
The requirements for....
If a system has more than 1 SQL Server Express 2008 will still run but limit for the various editions of SQL Server 2008 from the Express right through the Data Center editions.
Limitations:
CPUs: Only 1 CPU.
|
|
I have a SSIS package (exports some database tables --> CSV file) After creation of this package, I can run the package from Visual Studio or just by clicking it.
But it fails if i add to execute this package as a SQL Agent Job scheduled at some arbitrary...
Started by rainmaker on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Datasource connections, Run as : SQL Agent Service Account (this is also run under MymachineName\JOBUSERYou don't give details of the error message received when the package is run by the Agent, but you need to check the rights....
|
