I am trying to migrate some access queries to sql and have an error with the
'Last' statement as it is not a reconized function, can anyone advise on
this and suggest any links to site with info an likely issues when migrating
access queries to sql

Beeing new to sql-server I look for some pointers. I have a system,
written for Oracle
that uses sequences in order to get a primary key value. I see that
that is not supported in sql-server,

Sorry for the newbie question, but I would like to simply populate a
tracking table with 'I', 'U' or 'D' (and the PK id) based on the type
of change being made to the table with a trigger.  My question is:  Do
I have to query all the psuedo tables to do that?  ?  Or is there an

All,  I posted under another thread titled "Trigger, Identify Insert,
Update AND delete in one "  because I was thinking a trigger was the
way to go, but now I'm looking for a better idea from people with
experience in replication

i have Several Databases with the Same view in them (vCustomers)
I have to do work on these views (drop , modify etc) depending on the Data
Sent to us via partners
i have a Master database ( mymaster) well say

Is it possible to copy/backup a DB from a production server to a localhost
(with or without the data)?
Thanks

Hi, I work for a company that handles 100k Insurance claims per Day
Weve stared a new Part of the Web site that handles a new type of insurance
claim...
In our other system, they actually create duplicate of the claim for

I've read in the BOL best practice creating the tempdb; it states
create one data file for each CPU. In addition, it states to
create .x25 - 1.0 data files for each CPU.
I am wondering if I should also create multiple log files for each

I have successfully configured mirroring in SQL 2008. I use a witness
server and it is running in sync mode. I can fail over the databases
and everything works great; except one thing.
I have a SQL user called dmbuilder. When I created the database via

When I try to modify a Bit field's Allow Null to No, I get the message that
change can not be made without dropping the table. The table contains data.
How can I make this change while maintaining the data in the table?
Thanks

How can I make an exact copy of a table with indexes, constraints and all?
Thanks
Regards

Summary:
How can I ensure that sys.sql_dependencies is 100% up to date and
accurate prior to querying it for a list of dependencies?
Detail:

Is it possible to get what column name for a corresponding value?
e.g.
get the columnname where a value = 'tom' From tbl_login
Is this possible?

Sql Windows/32 ActiveX error
ActiveX object creation failed-please check that your
installation is valid.
How can i fix this error?  The user can execute the

I'm trying to update a single row, setting a value that is logically boolean
but defined as Bit. I want the bit to be 1 only if it is already 1 AND my
parameter is also 1, otherwise, I want the bit to be zero.
I tried this: