you probably never notice, but SSMS builds a default connection string that points to a specific database, like master, unless you selected or left <default> in place , so...

you can create a linked server to point to an excel spreadsheet, and then reference it just like shanghaigirl-1125377's example.

here's my detailed notes and example on getting it set up...

here was my test...i made a cross database synonym in one database,a dn then a procedure in the same database as the synonym:

create synonym MymasterView for SandBox.dbo.VW_FIXEDWIDTH

create procedure pr

as select...

i *think* this would give you a list of dependancy items that reference an existing synonym in a specific database.

note you can have global synonyms/ cross database synonyms in the...

i have this scalar function saved in my snippets, that basically strips chars that don't fit within desired ranges;

this strips your 0-31, but also spaces, punctuations and all high ascii...

i was trying a simple code...

jbayliss i'm not sure what the end results were from sp_MakeWebTask; i would assume it was a simple grid like results of the table?

if that's true, I tossed a CLR...

Georges link again for clarity:

http://www.sqlservercentral.com/scripts/Permissions/76450/

can't you change it so that the ending delimiter is comma-Carriage-Return instead of just CarriageReturn?

that would fix it i think.

go ahead and throw your cursor away.

the data you are looking for is already materialized for you;

the indexes maintain a count of the number of rows for every table.

try this...

another , better possibility os to create temp tables to hold the results of the two procs, and then use multiple temp tables:

the only issue with that is knowing...

sumith1andonly1 (11/15/2012)

---

i have the following:

Stored Procedure 1 calls Query 1

Stored Procedure 2 calls Query 2

i would like to have:

Stored Procedure 3 calling Query 1 and Query 2 and then combine...

glad this post helped you, ntingab!

pretty sure those settings are stored on the machine you set it up on.

for my SQL2012, it actually in %appdata%\Microsoft\SQL Server Management Studio\11.0\SqlStudio.bin,

and similar folders for 2008 or R2.

you'd want...

also, an express edition usually installs a named instance (.\SQLEXPRESS for example) and not a default instance that will answer to (local)

look in Control Panel/Administrative Tools>>Services and see if it's...