why can't you script the table out? and change dbo to the new schema name?

explain a bit more why you need to clone the table(and the data?) more than one...

what language are you using on your web page? what have you tried so far?

you gave us little information, and the question seems more oriented to the program you are...

with a non-express version of SQL, the SQLAgent is used to perform jobs on a schedule, like backups and other maintenance tasks.

since Express doesn't include the SQL Agent, you'll need...

edward are you familiar with the SqlCommand.ExecuteNonQuery Method, that is part of the (System.Data.SqlClient) class?

that is how you'd call a command that has...

the best way is to script the table out;

you can use the INTO [newtable] with a SELECT, like the script below for something fast and easy, but you'll...

better way? no...different ways , yes.

you are going to use the tools you know, and get the job done. I don't see a problem with that at all.

my background is...

billa i could not find the way to get more than 1000 records via linked server;

looks like it is much easier with powershell; by assigning it a page size, you...

i also have this saved which uses one of the DMV's to identify slow queries on the server:

use msdb

go

if not exists (select * from sys.schemas where name = 'MS_PerfDashboard')

exec('create schema...

without using SQL Profiler, or creating a Server Side Trace, it is not really possible. a server side trace has minimal impact, and I consider it a best practice to...

GlenParker (5/14/2010)

---

I am copying data from an inner join condition to select only applicable data for an external customer.

My problem is that I need to deselect the column attribute ie....

from msdn:

http://msdn.microsoft.com/en-us/library/ms189077.aspx

By default, the VIEW ANY DATABASE permission is granted to the public role. Therefore, by default, every user that connects to an instance of SQL Server can see all...

you have end users logging into your Server using SSMS?

anyway, I'm thinking because CONNECT rights give them read access to the master database, and sys.databases has the list of...

yep it's documented; what you are looking for is editing the "noise words" file;

mine happens to be located here:

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTDataoiseenu.txt.

if you look inside it, you'll see all single...

I'm a little twisted around i guess; you'r not doing this from a C# application like you said, or are you getting the estimated plan in your results to your...

if you are doing this from a .NET application, can't you jsut put the results in a DataTable and get the DataTable.Rows.Count?

otherwise i think you can get the "xx...