|
syntax question
Can anyone tell me what the @ below is and does please?
Thanks.
const string STR_SQL_USER_INSERT = "INSERT INTO tblUser(FirstName, " +
"LastName, LoginName, Password) VALUES(@FirstName, @LastName,
@LoginName, @Password)";
cmmUserInsert.Parameters.Add("@FirstName", SqlDbType.VarChar, 50,
"F ...
Wed, 5 Jan 2005 06:14:28 -0500
|
how to access table column description?
How can I programatically access column descriotion property? Thanks.
Robert
...
Wed, 5 Jan 2005 11:51:41 +0100
|
Which SQLServer ADO provider?
Simple question:
Should I use
"provider=sqloledb"
or
"provider=sqloledb.1"
When connecting using ADO 2.7/2.8 to SQLServer 2000 sp3a?
Thanks
Griff
...
Wed, 5 Jan 2005 10:41:33 -0000
|
Case sensitivity error!!
Hi,
1] I have a domain user group 'Domain_name \my group' added into my SQL
Server.
2] When I execute the following code ..
if not exists (select * from master.dbo.syslogins where loginname =
N'Domain_name\My Group')
exec sp_grantlogin N'Domain_name\My Group'
exec sp_defaultdb N'Domain_name\My Gro ...
Wed, 5 Jan 2005 01:29:02 -0800
|
Back up to tape failing
HI people.
I need some help with the following error.
Can not open backup device 'SFbackupDataT'. Device error or device offline. See the SQL Sever errpr log for more detials.[SQLSTATE 42000] [error 3201] Backup or restore operation terminating abnomally. [SQLSTATE 42000] (error 3013) Associated statement is ...
Wed, 05 Jan 2005 09:25:46 GMT
|
Replication - conflict tables
Hello,
I would like to know what are the options in SqlServer
to raise an alert when coflict is occur.
Creating a trigger on each conflict table that report me
after insert, is it proper solution?
Many Thanks for reply. ...
Wed, 5 Jan 2005 00:37:03 -0800
|
SQL Server was blocked by a query
Hi everybody,
This morning, one of our customer reported that their application became
very slow when trying to do a query to the SQL Server, after checking the
Locks/Process ID in EM, we found there was another query from the remote
site that was blocking the others, I let them killed the blocking Process
ID, ...
Wed, 5 Jan 2005 15:13:23 +0800
|
SQL job failed (General network error)
Good day SQL experts and seniors,
I have a SQL job which is scheduled to run everytime when SQL agent starts.
The job will invoke a stored procedure. This stored procedure will run
continuously using "While Loop" by referring to a flag stored inside a SQL
table. If the flag is set to "OFF", the stored proc ...
Tue, 4 Jan 2005 19:59:03 -0800
|
Strange and irritating connection problem.
Hi,
Here is my problem:
I connect to SQL Server 2000 on Win Svr 2003 through Access 2003 on XP Pro.
The server runs SERVER1 and SERVER1\BACKUPEXC instances of SQL Server.
It opens my project, connets to the DB1 using dbo1 credentials and shows
all objects.
However, at any time I want to perfrom an act ...
Tue, 4 Jan 2005 18:05:06 -0800
|
Did it really successfully install?
SQL 7 Standard on Windows 2000 Advanced Server SP2. I just installed =
SQL Server 7 on the server and although the installer ended successfully =
I have this in the sqlstp.log:
20:44:13 C:\PROGRA~1\MICROS~3\Common\IDE\IDE98\sqldbreg.exe -RegServer
20:44:13 Process Exit Code: (-2147312566) Error loading type ...
Tue, 4 Jan 2005 20:53:52 -0500
|
Database option "autoclose" is set. Why?
I have inherited a 2000 server with a database with "autoclose" set to
"true". It appears to fill the log with "Starting up database dbname"
messages. A search of MSDN yielded no explanation as to what this setting
really does or why one would wish to set it on. I am tempted to set it off.
Any wisdom?
...
Tue, 4 Jan 2005 11:43:06 -0800
|
Loss of inserted records during/after an insert
We have a system that records a data record for each cycle of a machine in an MS SQL Server database. These cycles take place approximately once every 10-12 seconds, and there are four stations on the machine, so we are writing approx. 24 records per minute. Our database contains four tables, one for each machine ...
Tue, 04 Jan 2005 18:45:41 GMT
|
Build SQL Statement for execution with variables
How do I build a sql statement using variable that will be run within SP.
I have the following:
**Temp folder is designed above
declare @CurrentDatabase nvarchar(128)
set @CurrentDatabase = 'abc'
insert #BackupSet_Header
exec ('restore headeronly from On_Demand_' & @CurrentDatabase)
I have written ...
Tue, 4 Jan 2005 13:43:01 -0500
|
Moving text fields from one server to another
I am trying to move text fields from one linked server to another. If the text field is under 8000 in length I can just use an update statement and it works. If it is over 8000 in length I was trying to use UPDATETEXT to update the field, but I can't seem to get it working. First of all it doesn't link it when I ...
Tue, 04 Jan 2005 18:43:32 GMT
|
Missing Statistics - sysindexes.rows = 0 for ClusteredIndex on 5 million row table.
Summary:
======
We have a situation where all queries to several large tables are performing
table scans because SQL Server statistics page believes there is no data in
a 5 million row table!
This table is one of a set of 5 on-line archive tables, each with the same
structure, eachj exhibiting the same prob ...
Tue, 4 Jan 2005 18:26:56 -0000
|