SQL Server express ? Here is the output of my select @@version:

Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)

 Apr 14 2006 01:12:25

 Copyright (c) 1988-2005 Microsoft Corporation

 Enterprise Edition on...

Bledu, on output screen of Script Wizard ?

It has 5 screens:

1- select database

2- choose script options

3- choose object type - I choose tables

4- select tables - I select at least...

Thanks, Daryl, for your code. I modified it and it is what I want. What I needed is a simple code that scripts out all tables from database in standard...

There was a good article today on this site, "Scripting permissions using catalog views in SQL Server 2005" - actually its a link to another site, you can use methodology...

Hi all,

Don't you have to detach database prior to moving files and then re-attach them back from new location ?

There is no another way to run bcp while xp_cmdshell is disabled.

But you may consider Bulk Load TSQL command or CLR (DLLs written in VB or C# and stored...

You are not able to use for already executed stored procedure ? As far I as know, these views display missing indexes for any form of SQL - stored procedure,...

I think that for cases when you have had viarious assignments with different database platforms the most appropriate title would be Database Engineer. This is the title I had some...

Forgot to mention, to display actual page data run this:

dbcc traceon (3604)

dbcc page(8,1,6904050,1) -- this example is for your 2nd line

dbcc traceoff (3604)

All these blocking records belong t o spid # 401. To find out who is this run select * from sysprocesses.

Next column shows database id. #2 is tempdb, to find...

You can play with this query, this table stores values that have been set up during installation:

select * from master.dbo.spt_values

where name ='trusted'

Unfortunately, in our environment all servers are mixed mode...

select

object_definition(object_id('dbo.SampleProcedure'))

Replace

WHERE id = @id AND SmpID = @SmpID                                             

with:

WHERE

CURRENT OF cust_cursor

In my tests it reduced...

RDC is Remote Desktop Connection.

I followed exactly all your steps, I alraedy had all them anabled, but unfortunately my perfmon is still not connecting to the server.

I connected to the server via RDC and in its Service Area Config for SQL Browser: Startup type :Automatice, Service status: Running. I also checked SQL Server Configuration Manager on...