jellybean (6/29/2015)

---

Hi everyone,

Thanks for all the comments. The following script appears to work for my needs:

use DBName

select * from sys.synonyms

where base_object_name LIKE '%SearchString%'

Ideally, I would like the...

well, for me, the question is:

if you created A certificate, why are you not using it.

I've always created a certificate, and then used EncryptByCert and DecryptByCert to handle the routines.

no...

rajemessage 14195 (6/28/2015)

---

hi,

I want to import excel file in sqlserver , i was informed that we have to pay of drivers like .jet and .ace.

i...

synonym definitions are not stored in sys.sql_modules.

they are actually in the sys.synonyms table, so whatever search you create needs to search multiple places;

you might want to include searching msdb.dbo.sysjobsteps, for...

no, it will not work.

database ownership changing breaks if the object called(ie your dbo.procedure) references another schema or another database.

in that case, the caller needs permissions to the objects involved...

an SSAS database backup file is usually saved as a name.abf file.

it sounds like you are trying to ATTACH an SSAS backup as if it were a Regular...

i think i see what you want, and you'll need to use dynamic SQL

build a complete update command, and execute it inside the cursor.

declare @isql varchar(max)

SELECT @isql ='update #temptable

set...

you should be able to navigate to the SSRS web site, click "Site Permissions" in the upper right

from there, fidn the tab that says security, and remove thewindows groups or...

that link you posted has a nice code example by bledu; that's the sort of code i'd put in an SSIS package's script task, so you can query SQL, and...

grkanth81 (6/25/2015)

---

Hi Karthik,

I know this is very old post of yours.

But I would like to know - Did you manage to find a solution for your question?

I am also looking...

try either procedure i offered, or the one Perry suggested.

when called with no parameters, it returns all logins.

there's a Microsoft proc you can download that extracts users and their hashed passwords named sp_help_revlogin;

you use it for exactly what you are asking copying/transferring existing windows users/groups/SQL users to...

there are dozens of scripts in the scripts section here on SSC that do what you are asking;

take a look and see if one will do the job for...

ok so my analysis of WHY it occurred is as follows, see if you agree with me:

LinqToSQL wants to try and maintain state of data, so instead of just doing...

because you are appending fields to each other, if any value is NULL, when sent to a text file, you end up with blank rows.

i'd start with bulletproofing the query...