shilpa.shankar87 (8/22/2011)

---

Msg 2760, Level 16, State 1, Procedure sp_helplogins_2, Line 460

The specified schema name "sys" either does not exist or you do not have permission to use it.

Im getting above...

nope, no non-clustered indexes either

indexes must always point to an object within a given database.....but the original table in the original database can have indexes up the wazoo. if they...

glad that my example got you thinking!

that one's from an old post where someone wanted ranges from like AA001,AA002,AA003 thru ZZ999

the table under that i tested for AAA0001 thru ZZZ9999,...

probably easiest to simply change the cursor to filter on only the databases that are not in SIMPLe recovery already

change the cursor definition to this:

declare c1 cursor for

select

...

here's something i use on my dev server...don't need anything in FULL recovery mode on that server at all...it's a play ground.:

USE MASTER

declare

@isql varchar(2000),

@dbname varchar(64)

declare c1 cursor for select name...

in my case, I have a couple of tables i need to update statistics on a couple of times a day in order to assure good performance.

Typically you really only...

can't be done.

by definition, an indexed view creates an index on an object in the database, so it becomes materialized as if it were a table, and an...

he probably pasted it right...the forum here strips out \n unless you html-ize...

sqlfriends (8/19/2011)

---

So in the result of the above script, does it mean the tables in truncate statement mean they don't have forign key constraint, and the tables in delete statement...

unless you can make specific assumptions, there's no easy way to do this.

if the first x number of columns are the same across all csv files, that might be a...

here's a snippet based on Seans example, that gets all the tables in FK hierarchy order and generates the Truncates/delete commands for you, so you don't have to drop and...

sp_helplogins returns two different result sets.

here's a table of the first result set i got from running this and scripting the table:

/*

SELECT *

INTO #sp_helpLogins

FROM OPENROWSET('SQLOLEDB','Server=DEV223;Trusted_Connection=Yes;Database=Master',

...

you can do it, but you still need an identity() column in your table.

here's an example, see how because of the assumed format with a max length of 5, you...

R.P.Rozema (8/19/2011)

---

Are you, by any chance, working on getting the iso week number? Because if you are, have a look at this article[/url] (remember to follow the discussions link, there...

just one more thing...you can do it kind of, but the stored proc must return unique column names

SELECT *

INTO #temp

FROM OPENROWSET('SQLOLEDB',

'Server=DEV223;

Trusted_Connection=Yes;

Database=Master',

'Set FmtOnly OFF;

EXEC dbo.sp_Who')

the above works.

if...