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

These can be hard to diagnose. The load on the server (either one) could be delaying the response to the connection attempt or the acknowledgement. In either case, you'd need...

When you execute the job, the SQL Agent service account (or a proxy that is configured) is who executes the batch file. That account needs to have rights to execute...

IF you don't have access to the SQL Server, there's no way to check if this is working. How are you planning on configuring alerts if you can't access the...

And don't shrink the log or database regularly. This is an emergency or rare utility for when something irregular happens.

You need to have regular full and LOG backups.

And you must convert this to a character string. Numbers do not allow multiple periods in them.

Even a solid network connection can get busy, and chances are it will happen when you have a backup running. It's not worth it. Get enough space for a local...