Hello group,
We have recently come up with a problem where SQLServer 2005 differs
from 2000.
We have an application role, which needs to run DDL to alter tables

I was wondering if anyone new how to access the call stack information
via TSQL
I'm currently in the process of migrating an application from Oracle
to Sql Server 2005

I'm obviously pretty new here please forgive what might be an easy answer.
(I have looked on Google to no avail).
In SSMS Express 2005, I created a new database user and added this user to
the db_datareader role. If I then go under "Roles | Database Roles |

Group,
I have a application that is distributed to a large corporation with close
to 1000 users that will be connecting to a SQL Server 2005 database. We
initiated a pilot program of the application with around 210 users as our

Hello, I was using the Import / Export Wizard
from Managment Studio 2005
-> tasks -> Import
when towards the end you can save the package

My platform is SQL Server 2005. One of the tables of my db has
28589928 rows and one of the fields is real. When I backup and restore
this database to another server (using the SQL Server internal tool)
and do a SELECT  SUM(<<field name>>) from <<table name>>, the results

Whenever I open a new file in the Studio, I need to type in a long
ugly statement to open a symmetric key. I keep this saved in a file
and paste it back there, but I don;t like this in particular, I was
wondering maybe there is a better way, like have a new file template

I have an installation of SS 2008 that's been installed with Windows
authentication.
After some Googling I've found that it is indeed possible to switch to SQL
Server authentication. My question is this: Is it possible to specify

Please bear with me - I’m quite new to MSSQL and the whole db domain.
The db itself is pretty simple. There are approx. 15 tables. The two
largest tables’ holds a total of 10 mill. entries.
1)

One of the developers where I work found that some of his code would
regularly cause index corruption in SQL Server 2000, post-sp4.
@@version is 8.00.2050 and I can repeat this, so I can't (re-)apply
the hotfix for KB article 929440.

I have two columns, for simplicity: Input and Output.
Output reflects the incremental difference of two chronolgocially
consecutive inputs.
problem: If a given input in the series is zero, then

I've got a bit of a problem calculating the duration of hours between
a clock-in time and a clock-out time.  It's a fairly straight-forward
process.  I put the clock-ins, clock-outs in a temp table and then do
an update on the table

Hi.  I am managing a SQL server that is running SQL 2005.  I really
like the management studio that comes with the full version because I
can view tables and easily create relationships and queries.  Is this
same level of control available with the SQL 2008 express edition?  I

dear sir/madam
 what is the syntex for changing default value.
table name is test
uno numeric(9)

Say I have 20 stored procedures that In some point I need to change TOP
clause from TOP 100 to TOP 150.
Which way is best way of doing so? I call the Stored procedue using .Net 3.5
It could be that I need to so only for certian users.