I need to take the roles and members on a 2005 database and script them out
into another database.  In other words, I have a role in database1 with
members a, b, c, d, etc.  and need to script out an identical role and
members in database 2.  When I highlight the roles in Mgt ...

I ran a view we have through the Profiler to see why a View we have is
taking so long to run and it came up with some recommendations.
I am trying to understand the recommendations.
There are about 30 create statistic creates:

I have the following table variable
declare @table Table(eventgroup varchar(50), eventtype varchar(50), date
datetime)
I run the insert  statement to fill the data (sample data)

I always thought putting criteria in the ON clause had the same effect
as putting it in the WHERE clause.  I like putting it in the WHERE
clause, because it seems to belong there.
This article -- http://www.bennadel.com/blog/284-SQL-Optimization-And-ON-Clause-vs-WHERE-Clause.htm

I use SQL server 2008 but I have found the same problem in SQL server 2005.
I have the Northwind database and if I create a database diagram for this
database
it doesn't show any information about which column is the foreign key in the

I have a table called Group with columns PKId and Name
I have also a table called Shift with columnd PKId and Name
These two has relation many to many so I use a relation table in between
with name ShiftGroup with columns ShiftPKId and GroupPKId

I'm thinking about adding an extra view layer that my sp/fn calls
instead of the view and some tables it's based from. Ideally I would
like to include a scalar fn as a field that could severely drop the
performance if it's calculated on the whole set.

Hi, I posted this question on microsoft.public.sqlserver.mseq but looks like
this forum is more appropriate.
I looks like a very easy task, but I couldn't find answer nowhere yet...
Using DatePart function I can find out what is day and week number of

I have been trying to find out if it's possible to create a database
diagram that include foreign key.
I have looked at sql server and Database Diagram and I haven't yet
find any way to add foreign key.

The unexpected behaviour mentioned in this post can be replicated using SQL
Server 2005 with SQLXML 4.0 and the AdventureWorks sample database that
comes with SQL Server 2005.
The following SQLXML updategram has been copied exactly as it appears in SQL

SQL 2005
I am having a problem trying to get this Stored Procedure to import an XML
File into a table
The errors I am getting when executing the stored procedure are;

I am writing an application that runs sql scripts into sql server 2008.
SSMS has a piece of functionality that will allow a script to be parsed -
but not run in the database.
does anybody know where I can find this functionality in SMO, I am hoping to

This seems like it should be easy but i can't find an answer.
I have a imagelist object with a number of images.
I want to loop thru the images and save them to the table.
Code I have so far: See Below.

nHi Guys
I am working on a patient table where a patient is prescribed two types of
drugs and there are two scenarios for how the prescription occurs:
1) Patient is prescribed drug A in different year and drug B in different year

In a table with three restrictions Check
when I run in INSERT or UPDATE stored procedure it is possible to know which
of the three restrictions of Error Check validacion
Sorry for the English translation but it is a soft