|
How to convert 12345 or '12345' to '12,345' in SQL?
Question as topic.
Thanks a lot
Chris ...
Fri, 14 Jan 2005 11:39:13 -0800
|
User Time Quotas
Does a configuration method exist to disconnect users from the DB after a
predetermined period of inactivity? Thanks to everyone for being part of the
group. ...
Fri, 14 Jan 2005 11:35:04 -0800
|
index question
We have a stored procedure that stopped working. I put it in the debugger and
discovered that the update statement takes forever - I stopped it after 2
minutes. This is the update statement: UPDATE tbltelemarketing SET download =
'2004-10-09 09:51:00' WHERE ID = 10617138. I had a unique index on the ID
colu ...
Fri, 14 Jan 2005 11:21:02 -0800
|
Enterprise Manager Shortcuts for Remote Servers
Hello and thank you in advance.
I have multiple databases on a single remote MSSQL server (from my ISP). I
can only access them via Enterprise Manager. My quandary is that every time
I log in, I have to click the server name, then wait for the database to
load, then sift through this enormous list to fin ...
Fri, 14 Jan 2005 11:07:01 -0800
|
row count different from QA and EM
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encod ...
Fri, 14 Jan 2005 12:53:57 -0600
|
How to copy all objects of a database in MSDE
Need to create a exact replica of a database with a different name in the
same MSDE environment on the same machine.
SQL Server Enterprise Mananger via an export was tried.
Although it does allow the Tables, Views and UserDefinedFunctions to be
selected and reports that they are done, they dont show up ...
Fri, 14 Jan 2005 10:09:01 -0800
|
Variable Syntax
What is wrong with this syntax? I can't get it to work.
Note: Assume this is a one row table.
declare @msg2 varchar(8000)
select @msg2 = select f1 from #temcm1 ...
Fri, 14 Jan 2005 10:04:29 -0800
|
DB in Loading State
There was a restore script executed against a test
database that failed and left the database in loading
state. I fixed the restore script and executed it again.
I need confirmation if this is alright. I noticed the
MDF and LDF files date changed to the current date. ...
Fri, 14 Jan 2005 09:54:54 -0800
|
How to move data files?
I need to move some data files from the c: drive to the d: drive. How do I
do it?
Thanks,
Michael ...
Fri, 14 Jan 2005 09:35:03 -0800
|
Mysterious Performance Degradation
Hi,
A batch job which updates a table in a SQL Server database took three hours
to run last week. Nothing changed except perhaps the database grew by 1%.
Suddenly this job takes 30+ hours to finish. I increased tempDB datafile,
log file to match the production database server - this same job runs in
abo ...
Fri, 14 Jan 2005 08:37:02 -0800
|
Backup Question
I have set up my server to use the simple recovery model. I understood this
to mean that the Transaction Log is not used. So why is it that my
Transaction Log is still being used and is growing? ...
Fri, 14 Jan 2005 08:13:01 -0800
|
newbie question
Hi,
i'm kinda new to Microsoft SQL Server. I've just finished my first
install. Now i want to be able to connect macintosh clients to the
server. I'm able to connect using windows 2000 authentification but not
with SQL Server authentification (in mixed mode).
When using "Aqua Data Studio" on my mac, when ...
Fri, 14 Jan 2005 16:03:46 GMT
|
Encypting The Database
Hello,
We have a requirement to encrypt our database so that us
DBA cannot read the infomation on it.
Can anyone point me to resource that will help us do this.
M ...
Fri, 14 Jan 2005 07:20:54 -0800
|
Componente Services + win xp sp2
Hi.
I've intalled windows xp service pack 2, since there I cant' view Component
Services -> Transaction Statistics from a remote server.
I'm not using XP Firewall.
Any ideia?
Thanks
Esio
...
Fri, 14 Jan 2005 13:04:49 -0300
|
SQL Server
Hi,
Version: SQL Server 2000 Enterprise Edition SP3
To trace a deadlock scenario, I turned on the required trace flags. (I know
that trace flag 1205 is not required to be turned on). As the SQL Log was
growing so big, I scheduled a SQL Server Job using sp_cycle_errorlog to
recycle the log every two hours.
...
Fri, 14 Jan 2005 06:25:05 -0800
|