|
QA Debugger
I need help resolving a problem our developers are having with Query Analyzer
debugger. They get an error "Server: Msg 504, Level 16, State 1, Procedure
sp_sdidebug, Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Unable to connect to debugger
on SALESTEMP (Error = 0x800706ba). Ensure that client-side ...
Fri, 14 Jan 2005 06:19:10 -0800
|
how can I
How can I get a value from a variable in one trigger to populate a variable
in another trigger. ...
Fri, 14 Jan 2005 06:07:02 -0800
|
hot fixes
Are there any fixes that I need to apply after applying sp3 or sp3a or I
should wait for sp4. ...
Fri, 14 Jan 2005 05:45:02 -0800
|
Named Instances
Is there any limit for installing named instances on a server? ...
Fri, 14 Jan 2005 05:27:02 -0800
|
Roles & Security - Baackground needed.
Dear All
We are trying to set up the Security Roles on our system
so that our users can only access the system through our
store procedures.
Our problem is that some of our SP uses dynamic SQL, these
procedures with the dynamic sql fail with the message:-
SELECT permission denied on object 'TABLENAM ...
Fri, 14 Jan 2005 04:31:23 -0800
|
SQL Server memory usage.
Hello Sezgin,
Based on my research, the following article has addressed the issue you
encountered:
FIX: Performance of a query that is run from a client program on a SQL
Server SP3 database is slow after you restart the instance of SQL Server
(815249)
http://support.microsoft.com/default.aspx?scid=KB ...
Fri, 14 Jan 2005 12:07:45 GMT
|
Urgent ... Excel export from Access larger than from SQL server??????
Does the access database your transfering into have
primary keys, relationships, indexes and the like ?
If so that could cause it.
BTW your (or mine if so apolgies) assumption that the data
in the SQL Server is 90k could be wrong again for the same
reason, as when transfering it doesn't transfer any
i ...
Fri, 14 Jan 2005 03:12:58 -0800
|
Lights needed on the T Log management
Hi,
I've got a quick question about the way SQL server handles the Transation
logs (in Full recovery mode).
Transations are kept in the log until the log is or backed up or truncate,
The size will be reduce will DBCC SHRINKxxx
My question is : After I truncate a log, will the next transactions be
append ...
Fri, 14 Jan 2005 11:58:01 +0100
|
check sql licence
Hi, May I know how to check what is my current sql licence installed? I've
learnt that in control panel, there is a SQL Licence setup icon which I can
check. But some of my MSSQL server don't have this icon. Can you help?
Thanks
andrew ...
Fri, 14 Jan 2005 01:43:07 -0800
|
Locking
Why does a simple SELECT statement take an Intent-Exclusive lock? Surely
there is no need to even think about excluding anything else when just
reading. For example SELECT * from pubs..authors aquires two locks - an
Intent-Exclusive table level lock on the clustered index and another
Intent-Exclusive table ...
Fri, 14 Jan 2005 00:03:02 -0800
|
Urgent ... Excel export from Access larger than from SQL server??????
Hi,
Thank you for taking time to help me out!!!
I have a table in my SQL Server 2000 that I need to export to an Excel
file.
When I export this table from the SQL Enterprise Manager (Export
data...) and export it in Excel97-2000 format, the file size is 90k.
If I link this same SQL table into an Acc ...
Fri, 14 Jan 2005 07:44:58 +0100
|
Estimate DB Size: how to calculate clustered and non-clustered ind
I am doing an estimation on db size based on this link:
http://msdn.microsoft.com/library/en-us/createdb/cm_8_des_02_92k3.asp?frame=true
How can I check which tables have clustered index and non-clustered index
fastly?
Thank you! ...
Thu, 13 Jan 2005 22:41:02 -0800
|
Stored Procedure
I am not sure why I cannot post this message! I've tried many times!
Original message:
Okay, let me first start with the abridged table structures:
Student Personal Details: (Table 1)
Student ID: Eg. 1111
Name: Eg. Abc
Student Sale Details (Table 2)
Student ID: Eg. Abc
Invoice Number: Eg. 10001111
...
Fri, 14 Jan 2005 13:37:33 +0800
|
Performance - transactions/second
Does anyone know how many transactions can SQL Server process per second?
Any suggestions on SQL Server performance testing tools?
Thanks! ...
Thu, 13 Jan 2005 19:07:02 -0800
|
sqlserveragent service
I'd like to configure a local windows account to run the SQLSERVERAGENT
service. However, I don't want to arbitrarily make this account an admin
account. What steps are necessary to grant a windows account enough rights
to do this job?
Windows 2003, SQL Server 2000, SP 3
Thanks in advance.
Mark
...
Thu, 13 Jan 2005 20:15:40 -0600
|