China ZhongZhan Aids Mei Mei
Sat, 18 Mar 2006 08:41:26 -0800
Killer!
http://onfinite.com/libraries/175399/440.jpg
elmar@digi-art.de
...
|
Embedding isolation level in SQL OLE DB connection string?
Thu, 16 Mar 2006 14:01:47 -0500
Is there any way to embed the desired connection isolation level in a SQL
OLE DB connection string? I saw that the property "Isolation Level" exists
on SQL OLE DB connections but couldn't find a way to get this into the
connection string (extended property didn't work)
For 3rd party products that take co ...
|
Different Default Date format for 2 SQL Server Instances
Wed, 15 Mar 2006 18:16:30 -0800
Hi,
We recently had a new environment created. The servers were all installed
as separate instances on the same physical machine.
For my first instance INST1
When I execute the following query exec getMyData '1964-11-19'
in query analyser everything is fine
from my (ASP) website everything is fine
...
|
User Pass.
Tue, 14 Mar 2006 13:29:57 -0500
I would appreicate if any one can let me know how I can findout the database
user password.
I don't wanna change the password, I have a system administrative rights in
SQL Server, is there any way to findout that.
Thanks
...
|
Loading SQL Server 2000 stored proc in SQL Server 2005
Tue, 14 Mar 2006 08:56:18 -0800
Greetings,
We've recently migrated our database from SQL Server 2000 to SQL Server
2005. Most of this migration has gone well with backup/restore, and a few
post steps...
One last issue remains, I'm trying to run a stored procedure in 2005 that
calls an extended stored procedure that was created with ...
|
BECOME A DOT.COM MILLIONAIRE WITH ONLY $5.99Cents or $1K.
Thu, 9 Mar 2006 22:20:03 -0500
BECOME A DOT.COM MILLIONAIRE
Invest $1,000. Get back up to
$3,000 a day ,$100,000 monthly. for 1 year. Silent Partners. Do no
work.
www.vosar.net http://www.vosar.net
416-903-5685
775-333-1125
invest@vosar.net mailto:invest@vosar.net ...
|
Group Query to include 0 values
Thu, 9 Mar 2006 13:50:28 -0800
I have to sum(NoWidgets) produced GROUP'ed By Station. The Widgets Produced
are in a subtable of the Widget Stations, so it works for the most part by
doing this:
Select Sum(NoWidgets) From WidgetData Inner Join StationData GROUP BY Station
Where I run into problems is when I want to sum the number of b ...
|
|
|
BECOME A DOT.COM MILLIONAIRE WITH ONLY $5.99Cents or $1K.
Thu, 9 Mar 2006 15:45:19 -0500
...
|
Dependance service or group failed to start - 1068
Wed, 8 Mar 2006 16:19:10 -0700
I am getting an error whenever I try to start the sqlserveragent. This
started happening about three days ago. I have not made any changed to the
computer users or permissions and it is a test environment on a local
computer.
The error is:
The dependency service or group failed to start error 1068
Any ...
|
Syntax - Query
Wed, 8 Mar 2006 12:01:30 -0800
OK, I have 2 fields: LastName and FirstName.
I need the syntax that will provide me the following:
LastName + ',' + Firstname
However, the field has a max length of 20 characters. So, if the last name
is greater than 18 charaters, then I need it to provide the following:
left(LastName,18) + ',' + left(firstn ...
|
