Alan,

What errors?

swekik, you need to run through the databases and query against sys.logins and use left joins to find those that aren't matched up. How many databases do you have?

I...

Getting a PMP isn't a bad idea. It gives you another skill you can potentially market. Plenty of people would like to hire a PM with development experience or vice...

What's the status of the corrupted DB? Can you connect to it and run a tail log backup?

Here, here, Barry. Anything requires time and sacrifice. My kids, my marriage, they all take work and time to continue to be something I can be proud of.

Manie,

Good luck and hope things improve.

And if anyone else wants to grab a shovel...

come on over. Always things to move around here. :w00t:

Interesting comments, and no complaints, Jeff. Just wondering. Usually I get a good diatribe if I've stoked your interest.

As I get older, I realize that no matter how much you...

Shrinking the transaction log regularly doesn't buy you time, it grows again as the two above mentioned.

The only time you shrink it is when some rare, one-time event (big load,...

Thanks for the update.

Your post makes no sense. Are you using SQL Server 2005 or MySQL? Please don't capitalize things that are not specific names.

You also need to ask a specific question. What...

Your exec returns a single value, not a result set.

You probably want to run this from SQLCMD or another client utility, not xp_cmdshell.

Your client tools are broken. Likely need an uninstall/reinstall.

You can join the queries or make a subquery.

select istekid,istek1+istek2 as Istek

from ST$Istek I

inner join ST$Kullanicilar K on I.Istek_Sorumlusu=K.id

where istek_durumu<20 and email...

There is information in Books Online on DDL triggers and lots of articles on CLR programming. In addition to Gail's questions, you should do some research and ask specific questions,...

There isn't a comment prompt in SQL Server. You can execute sqlcmd from the Windows command prompt and get data that you can send to a file or a program...

Please don't cross post. Answered here: http://www.sqlservercentral.com/Forums/Topic588085-149-1.aspx