RE: Replacing SAN on SQL 2000 Cluster
Vaeritas Licensting Sucks ass. I wouldnt be surprised if it didnt
2003-07-10
1 reads
Transaction Log
RE: ADO Code
Alan, If you using the code as is, ie no error trapping, then it is unlikely that permissions being the problem as by default errors are shown. When you see the blank page right click and select View source and see if any message is shown there. Other than that are you sure there is […]
2003-07-07
1 reads
RE: Locking problem
Could this be anything to do with implicit transactions? Maybe SQL 7 and 8 behave differently in this respect....
2003-07-01
RE: Storing an Excel Sheet in an SQL field.
Hi Henry, quote: So if you BLOBS are spreadsheets that change every week put them in the database. If the BLOBS are scaned documents don't bother. ... If you have static BLOB documents & Objects (for example scaned documents) don't bother putting them in the database. my BLOB's are mainly PDF files (all stored in […]
2003-06-24
RE: Thanks for this site ! Any similar for Oracle
bj007; Hey, I'm an Oracle DBA myself and for Oracle documentation, scripts, tech forums and support I use Oracle's Metalink support website. If you have an Oracle Support agreement then you have access to the site. The amount of searchable documents, scripts, forums, and technical support is not matched by any other company. It's not […]
2003-06-23
1 reads
RE: Copying Databases to New Server
Don't use the wizard. It's a piece of #@$%#%$# http://qa.sqlservercentral.com/columnists/ckempster/deattachandreattachdatabases.asp http://qa.sqlservercentral.com/columnists/rsharma/copydatabase.asp Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-06-19
RE: Master server vs. Target server
Are the master and targets at the same SP/patch level? Check @@Version. If you can't delte them from EM, use QA and whack them from msdb..sysjobs and msdb..sysjobsteps. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-06-19
1 reads
2003-06-18
1 reads
RE: Using variables within IN
I need to do this exact something, and have developed it using dynamic sql as mentioned. What I'm wondering is has anyone tried doing this with the in clause parm (sp input parameter) declared as a table type variable? I was just wondering if it was possible or not. My calling app is VB and […]
2003-06-11
1 reads
RE: Status: Performing completion actions.....
Does the job contain any e-mail notification? If so, maybe try it without such notification and see if it runs to completion.
2003-06-10
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