2005-03-14
2 reads
continuous deployment (CD)
RE: Returning a recordset and an output parameter
You could try to open the recordset in an alternative way: g_rsData.Open cmdSubCommand, , adOpenStatic, adLockReadOnly Set g_rsData.ActiveConnection = Nothing m_lngDataRecordCount = cmdSubCommand.Parameters("@RecordCount") This does the trick in my applications. Erik
2005-01-27
2 reads
RE: DTS: Export to Excel: "Spreadsheet Full"
The maximum worksheet size in Excel is 65,536 rows by 256 columns, so it sounds like you have hit that limit. However, you can of course have multiple worksheets within a workbook. This is a hell of a lot of data for a spreadsheet to handle. Perhaps the time has come to consider a database […]
2004-11-08
RE: Question of the Day for 08 Oct 2004
"Answer B is just plain wrong"Answer B is only partially wrong. Primary Keys cannot be changed.
2004-11-01
RE: Permissions dilema
Hi everyone, I posted a response and just checked and the response is not posted for some reason. He is using Windows login. The SP has two insert statements, one is to database X on server 1 and other is to database Y on server 2. The insert to database X succeeds, and the other […]
2004-09-30
RE: Just-in Time Debugger for VBScript Not Launching for XP Client
The script debugger is just that, a debugger for VBScript. You can't debug anything other than VBScripts.
2004-09-02
RE: SQL Server backups vs SQL LiteSpeed
Give MiniSQLBackup a spin, at http://www.yohz.com.Regards Peter Yeoh yohz Software
2004-06-19
RE: right fill string characters
Thanks Antares... didn't know that. Hey paolice... how do you get DataLength to return the "defined length of your table's columns"? Couldn't find a thing about that in BOL.
2004-05-18
RE: Multiple instances of system moniter in the same MMC
Thank you so much!!! That will work!Juanita
2004-03-22
Result sort order differs since DB Maint. Job
Hi All,I had users complaining about performance issues in a database, so I ran a db maintenance plan and selected the option to reorganise data and index pages.Now the performance is beautiful...however some stored procedures no longer return data in the sort order they were once in. For example I have a stored proc that […]
2004-02-22
1 reads
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
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