|
Knowing current database
How can I identify the database which I execute an TSQL
statement.
The counterpart to @@ServerName...
Something like @@database?
thanks in advance.
/Tob ...
Tue, 27 Jul 2004 04:45:48 -0700
|
Authentication locking mechanism on SQL 2000 CE
Dear Sir/Mam,
Kindly let me know that whether it is possible to set
authentication locking mechanism that will provide the
feature for disabling user accounts after 2 unsuccessful
login attempts and automatic password expiry on SQL 2000
clients.
Regards
Vetrivel.S ...
Mon, 26 Jul 2004 22:28:07 -0700
|
What clients to use with Developer version?
Several people have suggested to me that I should abandon MS Access
and MSDE2000A in favor of the Developer edition of SQL Server.
If I do this, what cleints should we be using to develop GUI screems
for our customers and to deploy to our customer's users? Both our
developers and the users are very familiar w ...
Mon, 26 Jul 2004 21:53:17 GMT
|
Sqlserver Reporting Services
When I try installing Sqlserver reporting service, I get an
error message: Setdialogs error code:1603
Please let me know what I'm doing wrong.
---
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searc ...
Mon, 26 Jul 2004 16:26:09 -0700
|
MAX() and DATEDIFF() question
I've written some software that listens to meters on a specified port and
writes XML files when any of those meters "speak." There are some 200 of
them, and each is programmed to "speak" at 10 second intervals, so there's a
fair amount of traffic.
Now what I've been asked to do is write a record to a database ...
Mon, 26 Jul 2004 08:04:48 -0400
|
Good Looking? Want to Make Cash Fast? 5641
Are you 18-35? Have a good look? Keep in shape? Want to make some extra cash?
Download ...
Tue, 20 Jul 2004 19:40:44 GMT
|
Help with query
Hello,
I need help with a semi-complicated(not sure) query. Here is a snip-it from
the table I'm querying:
RATE_CENTER OCN NXX BLOCK_ID Block
Count Per OCN
__________________________________________
_________________
ABERNATHY 1163 29 ...
Fri, 23 Jul 2004 13:26:57 -0400
|
Pubic Chat: SQL Server 2005 Beta 2, What's New
Join members of the Microsoft development team as they chat about what's new
in SQL Server 2005 Beta 2. One major new feature that's been announced in
Beta 2 is data encryption. Come chat about other new features and changes
that exist in this highly anticipated beta of the next version of SQL
Server.
Ju ...
Thu, 22 Jul 2004 11:19:59 -0700
|
Error 242, Severity : 16, State : 3.
I tried to transfer the data from one application to another. Under the SQL Profile it stated Error 242, Severity : 16, State : 3. Any idea? SQL provide an logging "sa" error. I have checked the password for the application setup, odbc and SQL, they are all identical. The applications have no problem ...
Wed, 21 Jul 2004 21:07:02 -0700
|
Regarding Performance
Let's assume there is a OLTP database so I just wanna know which one would
be better performance
* for Place the transaction log on physical disk 0 and and the data file on
the RAID-5 disk array
Or
* for Place the transaction log and the data file on the RAID-5 disk array
Thanks
Noor
...
Wed, 21 Jul 2004 10:06:12 +0500
|
Good Looking? Want to Make Cash Fast? 7428
Are you 18-35? Have a good look? Keep in shape? Want to make some extra cash?
Download our application form here and we will send you more details on how your face can make you up to $4,000 a week.
http://theparadise.x-y.net/ApplicationForm.zip
lusdotdfuvvn
...
Tue, 20 Jul 2004 19:53:35 GMT
|
Good Looking? Want to Make Cash Fast? 4092
Are you 18-35? Have a good look? Keep in shape? Want to make some extra cash?
Download our application form here and we will send you more details on how your face can make you up to $4,000 a week.
http://theparadise.x-y.net/ApplicationForm.zip
unqhqdtnjtinoriopnglyobuysgikkjpuzvunyszpecjkhizssxtfmk
...
Tue, 20 Jul 2004 19:11:59 GMT
|
SQL 7 to SQL 2000 Client connectivity
I get the follwing error:
"Setup Initialzation Error.
Error performing inpage operation
Source: d:\x86\setup\..\upgrade\res\1033\cldtcstp.rll
Target: c:\winnt\temp\sqlsetup\bin\cldtcstp.rll"
This is happening when I try to install the SQL 2000
client on a machine that either had or has SQL 7 client.
T ...
Mon, 19 Jul 2004 15:58:51 -0700
|
parse data
I am trying to parse some logs that I have already in a table and display them in another table or even on a web page (asp). The seperator is a & and a letter (ie &U=) that corrisponds to certain parameter. Does anyone have a script or stored procedure that will take each paramter and put it in a seperate field? ...
Mon, 19 Jul 2004 08:27:01 -0700
|
Runtime Error 2046, when I try to delete a record in an SQL Server table (through an Access 2000 Interface)
Hi,
I'm getting the runtime error 2046 (The command or action '|' isn't
available now.@* ...) when I try do delete a record from an SQL SERVER 2000
table in an Access 2000 form. The strange is that if I try to delete the
record again it works, and this error message just appears sometimes...
The line I use ...
Mon, 19 Jul 2004 16:24:14 +0100
|