SQL Server Management Studio Crashing
Thu, 1 May 2008 06:11:00 -0700
I'm unable to open SQL Server Management Studio. I get and error that it has
encountered a problem and needs to close. I'm using a dell latitude D610
laptop with winxp pro service pack 2. SQL server is 2005 standard edition
service pack 2. I've unistalled and reinstalled both sql server and the .net
2.0 fram ...
|
osql licensing
Mon, 28 Apr 2008 13:02:01 -0700
Hi,
SQLServer 2000 Personal Edition SP4
Simple Question:
I have a small environment with one GUI computer and one Database computer.
I have one license for SQLServer 2000 Personal and Standard Editions (using
Personal)
If I install the database components on the database computer, am I licensed
(am ...
|
Database Mirrioring - Disconnect
Tue, 22 Apr 2008 20:11:44 -0400
Dear professional,
I want to ask one question regarding Database Mirroring. For last 1 year
databse mirroring works fine and suddenly the mirroring status changed to
disconnect.
Any idea what can be the reason for disconnection?
Thanks
...
|
MSSQL audit, compliance and penetration test from single console.
Mon, 21 Apr 2008 00:08:09 -0700 (PDT)
Hi guys,
MSSQL DBA?s life could become easier with the help of a new tool named
Secure Auditor which is capable of performing enumeration, audit,
penetration test and forensics on MSSQL databases. It is the most cost
effective tool in its domain as it includes 30 additional tools like
MSSQL access rights audi ...
|
Messaging Broker.
Sat, 19 Apr 2008 08:53:01 -0400
Hi Professionals,
I want to know how database let application know is any DML operation
occurs.
We have an application in C++ and in the morning it cached all the USERID
and Password into the memory, now what I want is if user change the
password, we have to have any mechanism through which database let ...
|
CLR and T-SQL dubugging with vs2008
Fri, 18 Apr 2008 10:36:09 +0200
Hi at all,
one week ago, I tried to resolve vs2008 debugging problem; this is my
scenario:
Windows Vista x64, VS2008 Team Suite, SQL2005. I tried to debug a local CLR
stored procedure from VS2008; I'm not Local Administrator; I' m in local
user group.
In SQL2005 I'm sysadmin. But whe I try to lunch "Step Into ...
|
Termianl Server application causes SQL server to bog
Wed, 16 Apr 2008 13:58:00 -0700
We have a custom application that seems to run fine but when multipe users on
a Terminal Server run it at the same time the processor time for the sqlsrvr
service on the SQL server goes to max.
We can see in the SQL enterprise manager that the CurentActivity\ProcessInfo
that the Process ID for all requests fr ...
|
|
|
SQL Server Express, limitations?
Tue, 15 Apr 2008 12:47:03 -0700
Hey guys, couple of questions... I just installed SQL Server 2005 Express on
a laptop. I created a database on it, and I'm trying to get into the table,
but I can't. There is no way for me to physically open the database for
modification in SQL Express? To make matters worse, I am completely unable to
see my ...
|
how to insert one Parent and Multiple child records into SQL Serve
Tue, 15 Apr 2008 08:34:01 -0700
Hi,
I have created 2 tables, Orders and Order Items. Using C# I am able to add
a single order and use that order's ID as an input for OrdersItems table to
insert one record within a Transaction.
But I need to have multiple order items for one order.
Please help, as I urgently need to solve my problem...
T ...
|
Sprocs v. embedded queries
Mon, 14 Apr 2008 12:08:00 -0700
I've read that the advantages of sprocs over embedded queries is that the
former are compiled once.
Does one loose the advantages of stored procedures when one concatentates a
lot of strings together and then uses the EXEC function to execute the
subsequent query? I'm seeing a lot of this in the stored proc ...
|
