SELECT DATEADD(YEAR, -1, DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) -3, 0))

SELECT DATEADD(YEAR, -1, DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0))

elham_azizi_62 (10/25/2010)

---

hi all.

we want to log changing data such as isert,delete and update that users perform.we can do this.but now we want to khnow

which user do this changes?I want...

DMV sys.dm_exec_connections returns client IP. For example:

select client_net_address, session_id from sys.dm_exec_connections where net_transport = 'TCP'

brian_winzeler (10/21/2010)

---

Msg 15225, Level 11, State 1, Procedure sp_rename, Line 332

No item by the name of 'ix_name' could be found in the current database 'db', given that @itemtype was input...

It may not cause security issues.

But, in my opinion, it is better to give DBMail access to only limited number of users.

Because, it is possible to send large number...

The SQL Server Agent service account should be a domain account and should have read-write permission to on folder \\machineB\Backup.

Snapshot replication get does not ins/upd/del individual rows. It does bcp. By default bcp does not fire triggers.

Why creating a job to run a .BAT which runs a SQL command?

You can do that in T-SQL job right? Are you trying to run this on Express edition...?

If you...

Objects created by users belonging to db_owner role gets dbo schema (this was the behavior in SQL Server 2000, if I remember correctly). I think your windows user does not...

Check whether WMI (Windows Management Instrumentation) service is running on the server.

Set Max Server Memory for the SQL Server instance.

srik780 (9/24/2010)

---

hi

i altered model db to another path after that i restarted the services but it cant and unable to connect to the server also plz help...

I think the job history entry for 11-09-10 has been removed from msdb database.

Regarding this situation I have following suggestions:

1) Increase the job history log size (right click on SQL...

Yes. Without them (SMK, DMK and certificate)...

Try "NOT FOR REPLICATION" option and test it.

Hope it helps you.