stating the obvious, you've got to disable their access.

Here's how:

from Enterprise Manager, right click on the server, and expand the "Security Folder" so you can see "Logins"

You might see BUILTIN\Administrators...

ok you'd get that eror if there was a weird value in

can you run this and see what the last run date value is?

[font="Courier New"]SELECT @@servername AS [Server],

J.name...

does the stored procedure AxSP_Adhoc_PerformConsistencyCheck exist in the master database, or the default database of the user AOANHSS\sqlnashrep?

if it exists in master, but the default database for AOANHSS\sqlnashrep is "DevDB",...

because the backup came from your supplier, and not from your server, the user "eu\genetica" is "orphaned...that is, every server in the work may have a user named "Bob", bu...

sp_help the table, and find the name of the Foreign key you want to drop.

issue the drop command like this:

sp_help gmact

alter table gmact drop constraint FK__GMACT__AACCOMPLT__66960AE6

You can't automatically do it, some decisions have to be made. Also remember a functionality may exist that would use a table in the database, but just hasn't been used...

your views and indexes should port right over, but triggers,procedures and functions will need to be hand edited; there just isn't an easy way to move those over, sorry.

Are you...

yes; each service can be uninstalled, or installed after the normal database services install.

Just like any other program, go to add/remove programs in teh control panel, find SQL 2005, adn...

duplicate post...continue to follow the thread here:

http://www.sqlservercentral.com/Forums/Topic653232-149-1.aspx

I'd take a wild guess and say: add up the value of all your machines, servers and printers.

if you assume that a machine should last 5 years before it gets...

[font="Courier New"]

SELECT CONVERT(DATETIME,'20080204') --converts cleanly, and displays as '2008-02-04 00:00:00.000'

SELECT CONVERT(VARCHAR,CONVERT(DATETIME,'20080204'),101) --the desired format '02/04/2008'[/font]

Hi Alex;

Wow if you'd provided that table definition up front, we wouldn't have gone thru two pages of possible solutions and misunderstandings;

Help us help you! when you post in...

I agree with Jeff on the different execution plans...

take this part for example:

CREATE PROC [dbo].[s4sp_IFrames_Search]

@AffiliateId int,

@Zip varchar(12),

@curriculumid int = 0,

@ExcludeClientID int = 0

because you've assigned default values, the execution...

What have you tried so far? what is the real, full CREATE statement for dbo.Alpha? is there a primary key?

how do you know what row either "T" is ? there's...

here is a delete example. hope that helps, without more details it's tough.

SET ROWCOUNT 50000

WHILE 1=1

BEGIN

DELETE FROM dbo.myTable ...