RE: DTSGlobalVariables
hi dude, thanks 4 your answer.but i need to do something like this:select * from table where fieldvalue= <dtsglobalvar1>u got it?i need to use an external parameter to find data on my db. thanks a lot. sl3
2004-08-17
2 reads
training
RE: Calling A DTS Package from a Stored Procedure
Provided you don't use dynamic SQL inside your stored procedure you should be able to give access to the xp_cmdshell command just specifically to the stored procedure and provide execute permissions for that stored procedure to the web user.Alternatively, you could modify the stored procedure to insert a row into a queing table - a […]
2004-08-03
RE: Database Change Management Best Practices : Achieving an Automated App
It is, especially when you have to license all developers. I've not successfully licensed any product for everyone.
2004-07-28
RE: SQL Server 2005 Express Questions
I went ahead and setup the following on my server at home:Virtual Server 2005 with the SQL Server Express2005 and all the VS2005 betas. If you install any of the other Betas (which you might as well if you already installed .NET 2.0) then you can just set up a data project and fly from […]
2004-07-25
2004-07-22
RE: logging updates
The easiest thing to do would be to add an update_script column to the table. You can then just put the script that updated it in there. Triggers won't capture this level of detail.
2004-06-28
Stored Procedure Fails Only When Called By Agent
I have three stored procedures that do the flowing tasks: 1. connect to and add logins for 12 remote (WAN) SQL servers2. Drop data on the local server and re-add it table at a time from each remote server, one at a time, for 5 tables.3. Disconnect from the sites.These stored procedures work fine when run from Query […]
2004-05-06
2 reads
RE: Updating a view in SQL 2000
I just did the same with Access 2003 (don't have Access 2000). It worked perfectly for me.
2003-12-31
RE: Freeware Client Utility for SQL Server 2000?
As described it would appear you are still violating the license. The license is to allow you to connect. If you connect without the Microsoft software but with something else, you still connect. If you plan to do so without a license, just use Query Analyzer anyway, you are no MORE in violation. Edited by […]
2003-12-08
RE: Creating a PDF from a Stored Procedure
I've tried and it works quite great. However I would like to know if it's possible to use different letter sizes and formats (bold, italic) and if it's possible to save the file in any directory.
2003-10-14
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers