I struggle to get this going i would like to insert data into 2 tmp
tables in a view.
If i run the code on it's own it works perfectly until i want to create
a view it complains about the INSERT

I am trying to:
1. Create a SQL database (I am working with SQL 2005 Express)
2. with a C# code
3. when the user is not the computer administrator.

Panicked, as usual. Who says it's great being a sole proprietor?
Three tables: A_Appointment, AX_Appointment_Entity and E_Entity.
AX_Appointment_Entity is an intersect/association table between
A_Appointment and E_Entity. One appointment may have many attendees

my first post here...hope it goes well. I'm currently working on
stored procedure where I translated some reporting language into T-SQL
The logic:
I have a group of tables containing important values for calculation.

I've got a quandry - I have a detailed database that handles advert
orders between a design agency and printers / magazines etc.
I want to add up the total spent by the client and put the results to a
field.

I have this command line for backup:
BACKUP DATABASE [MyDB] TO  DISK = N'C:\backup\MyDB_daily.BAK' WITH  INIT ,  NOUNLOAD ,  NAME = N'MyDB_daily_backup',  SKIP ,
STATS = 10,  NOFORMAT
but Id like this name of backup:

Do aggregate functions (sum, count, min, max) inherently cause table
locks?
More concretely, would the following query typically result in a table
lock?

One of our employee made a mistake and deleted something from database.
I would like to recover that log file without restoring the backup and
the other log files. The reason I want to do this is our database is
getting real time information I cannot shut down the database. Is there

Dear Memebers,
I have a critical problem. I have an application is running on 64 bit
machine. It used to be running on 32 bit machine. That application is
using a Stored Procedure that uses SELECT, INSERT, UPDATE statements.

I have an old 2000 bak file for a db that I would now like restored
onto sql server 2005.  I keep erroring out though, this is what I'm
doing:
Went to Restore Database in sql 2005, selected the db I want it

SQL Server 2000 8.00.760 (SP3)
I've been working on a test system and the following UDF worked fine.
It runs in the "current" database, and references another database on
the same server called 127-SuperQuote.

I have spent the best part of 4 days trying to connect to SQL 2005
express from an winforms app! Yes , I have checked surface config and
TCP/IP blah blah ...
I have trawled the net and spent countless hours on MSDN and many have

Is there an equivalent in mssql to SQL Anywhere's GET_IDENTITY which
reserves the next autoinc value for a table?  Yes I know about
@@Identity and SCOPE_IDENTITY.  I need to get the next autoinc value
_before_ I insert the record due to the way the existing application

We are facing design issues, Could you please advice us how to proceed?
Problem description: Web App will pass a complex dynamic SQL query to
backend and it should return result set as fast as it can
Issue 1: SQL query will have lot of JOINS and WHERE clause

I was wondering if it is possible to continuously query a real-time
datastream using SQL Server. Does anyone have any experience of this? I
have found LINUX based systems such as Borealis and STREAM. I would
prefer to use a Windows based system as the program using the query