RE: Howto also copy/paste column name in Query Analyze
Or change the output to text instead of grid.
2003-11-26
events
RE: Howto also copy/paste column name in Query Analyze
Not that I know. Unless you include first the columns that you need to copy in the select clause, so they are all contiguous.
2003-11-26
RE: Mystery auto "recovering"
Stop the server and restarted with sqlservr.exe from the command line, and post here anything unusual you find.
2003-11-26
RE: SQL Mail
Here is what's happening. SQL Mail sends out the query results as a text file. Now if we try to save this file with .csv extension, and open in excel, it does not work. But when we save it as .csv and select the ansi format, it works. How can we automate the process ? […]
2003-11-26
RE: DTS & Version Control
I just did a quick search and our source safe contains an even 200 DTS packages. Fortunately I have only two databases to deploy these two. However, I found just recently one ex employee (not ex because of this, but it is symptomatic) has been storing his on the server. He APPEARS to have also […]
2003-11-25
1 reads
RE: DTS & Version Control
Where I work, we came up with almost the exact same methodology as Ferguson, with one minor extra tweak. (I have no DTS programming skills, so please pardon me if I get some of the terms wrong here.) In every DTS package we added a global variable named "Version". This variable is not used anywhere, […]
2003-11-25
RE: DTS & Version Control
We use Microsoft Source Safe and have had no issues in that rergard. I looked at the meta data stuff briefly, and am embarassed (or Microsoft should be!) that I have no idea what all that stuff really does.
2003-11-24
1 reads
RE: DTS & Version Control
Ferguson, Thanks for the reply, have you had any complications ( other than not being able to show dependencies/impact analysis ) from storing the DTS packages as structured storage files in your versioning tool ? Also I think it might be possible to do something with the Meta Data Services Packages for your dependencies/impact analys […]
2003-11-24
RE: DTS & Version Control
I required our group, from the beginning, to not store them in the database. That's very contrary to what most people do, but from my perspective it made them more "normal" in terms of source control. We leave them in the structured file format and store them in source safe, and deploy them much as […]
2003-11-24
1 reads
RE: dbo to add rolemember???
Are you having to use SQL Server logins? If not, use Windows groups. The security can then manage permissions by managing the Windows group. Saves a bunch of cleanup for when a person leaves and reduces the work when a person needs to be added. K. Brian Kelley, GSEC http://www.truthsolutions.com/ Author: Start to Finish Guide […]
2003-11-21
2 reads
Blogs
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...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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