Viewing 15 posts - 16 through 30 (of 143 total)
@bob-2 - all good. Collation is specified at a number of levels - database, column then explicitly in your query if you wish. There is also a...
February 26, 2009 at 5:11 pm
Thankyou Lynn for posting what I was thinking. The OP is asking for automatic translation of data (label text, etc.) if I understand it correctly, yet we have a discussion...
February 25, 2009 at 9:20 pm
Happy to help!
Regards,
Jacob
February 25, 2009 at 12:30 am
Sorry Gordon, re-reading my original post I see it wasn't especially clear. You will only see the Windows login of the user actually running the BACKUP/RESTORE statement (you in this...
February 23, 2009 at 3:50 pm
Hello Gordon,
Do you want to be able to see who is running the SQL statement? Run SQL Profiler against the server in question and look at the "NTUserName"...
February 22, 2009 at 7:46 pm
Razi,
There are a lot of examples on here - just search for "regex" and you'll find what you need. Matt Miller especially has provided samples:
http://www.sqlservercentral.com/Forums/Topic490684-149-1.aspx?Highlight=regex
Regards,
Jacob
February 22, 2009 at 5:02 pm
Gaby,
You may also want to amend the article to include the Excel 2007 methodology. Eg. using the Microsoft.ACE.OLEDB.12.0 provider with the Office 2007 System Driver installed.
And re: the...
February 19, 2009 at 5:22 pm
Excellent data and analysis Kendal - we have a very similar hardware environment to yours from the sound of it (PE2950s, PV220S and MD1000s).
I don't suppose you'd have the time...
February 18, 2009 at 4:29 pm
I've not had a problem outputting a UTF-8 flat file. I just whipped up a quick test table containing 2 columns (int, nvarchar(256)) and populated it with some sample UTF-8...
January 28, 2009 at 4:09 pm
In that case you will have to use Ramesh's approach (if you want to use sysindexes). Make sure that the local server collation matches the remote server collation...
January 21, 2009 at 1:09 am
As Matt points out FOR XML is your friend here if you insist on doing this on the DB server. Here's a typical approach, suitable for dumping directly into a...
January 21, 2009 at 12:59 am
Two things:
1) Using sysindexes.rows (or any approach based on metadata from the system tables) is not guaranteed to give an accurate value. If you just need an approximate answer as...
January 21, 2009 at 12:06 am
Jeff Moden (1/20/2009)
But it wouldn't reset to 1 for the same person, would it?
Ah, I missed that key point 😀
In that case no, I've never seen a business case to...
January 20, 2009 at 3:28 pm
I just remembered another business case for this methodology: implementing a state machine that mimics a real-world transactional process. I've had occasion in the past to do this to represent...
January 19, 2009 at 9:21 pm
Jeff Moden (1/19/2009)
...but would you need to restart the numbering each time a customer changes (or other thing) within the same day as in the original data I posted?
In the...
January 19, 2009 at 9:05 pm
Viewing 15 posts - 16 through 30 (of 143 total)