RE: Table Alteration Autiditng
Thank you for the product information. I have recently looked at some of their products, but did not see this one. Doug
2004-05-05
Restore
RE: Using 3rd party software for SQL Server backups
Thanks for the info, SQLBill. I am fighting this with every resource I have. This info will really help!/S
2004-05-01
RE: Need some good design advice!
As per BOL the max number of table in a SELECT statement is 256. Here is something from Inside SQL Server 2000 Multiple-Table Joins According to some folklore, SQL Server "does not optimize" joins of more than four tables. There was some truth to this in earlier versions of SQL Server, but in SQL Server […]
2004-04-28
RE: xp_cmdshell
is it possible to start a program (with parameters)from a stored procedure or a trigger. and the program should run out of process .i mean not using the same memory of sql server??rgdsramesh
2004-04-28
2004-04-22
2004-04-21
DTS Job - Job Failed Warning in the Event Log
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-04-19
RE: pls explain Outer Joins Useing = and *
In BOL one can read Transact-SQL Joins In earlier versions of Microsoft® SQL Server™ 2000, left and right outer join conditions were specified in the WHERE clause using the *= and =* operators. In some cases, this syntax results in an ambiguous query that can be interpreted in more than one way. SQL-92 compliant outer […]
2004-04-19
RE: Forcing Exception logging not be SUBJECT to ROLLBACK inside a transaction
When the outer transaction is rolled back does not it roll back all modifications, irrespective of any commits by the inner transactions? It makes no difference whether you have transactions in the procedure. (as shown below) create table logger (logentry varchar (30)) gocreate proc Testproc @entry varchar(30) as begin tran insert into logger values (@entry) […]
2004-04-15
RE: Determine Location Within DTS Package
You can't use @@servername or run any other query. Running a query requires you connect to a server. You have to know what server you are connecting to. That's the whole point of this exercise.
2004-04-08
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