*cheers*, even though I have not implemented it. I have read recommendation where removing the Local Admin would be a good idea then not everyone has access to your...

Your welcome, CAST(Field_Value as INT) will round down so it works.

But if your users enter a value that is two decimal places then this idea has a small glitch. ...

Markus (3/27/2009)

---

A reboot makes the problem go away for about 4-6 weeks. I follow what you say about TEMPDB but I am thinking that is not the issue since...

Del Murray (3/27/2009)

---

Mohit ..

Are you sure that if I backup the Log with a Logbackup on the Principal that the truncation of the Principal Log will be reflected in the...

Please don't cross post, replies here.

Heh gooders those quotes are always annoying but instead of using xp_sendmail (SQL Mail); I would recommend you use sp_send_dbmail (Database Mail). It is more secure and does not require...

May I ask why you want to do this? From the sounds of it these databases are separate entities. If that is the case by merging them all...

Hello,

Try ...

SELECT 1 AS SortKey, *

FROM tbl_Listings

WHERE Location='Hometown'

UNION ALL

SELECT 2 AS SortKey, *

FROM tbl_Listings

WHERE Location<>'Hometown'

AND Location not like 'RM%'

...

SQL server 2005 comes with native encryption ..

have a read at ..

http://www.databasejournal.com/features/mssql/article.php/3483931/SQL-Server-2005-Security---Part-3-Encryption.htm

And read up on Encryption in Books Online.

If you need further help post you questions here I am sure...

1) Take T-Log backup of Transaction log of the database in question.

2) Restore the most recent full backup to another database name on server.

3) Restore any Diff/T-Log backups you have.

4)...

Ohh you asked how to recover database after you broke mirroring ..

RESTORE DATABASE DBName WITH Recovery

How to break mirror:

ALTER DATABASE DBName WITH PARTNER OFF

Ref: http://sqllearnings.blogspot.com/search/label/Database%20Mirroring

Del Murray (3/26/2009)

---

4. Copy the log file backup from 3 (above) to the mirror server and make it the same name as the currently used logfile. (Replace the big xxx.log...

If you broke the mirror you'll have to rebuild it anyways. Because both databases will be out of sync as soon as you truncate the log.

If Mirror...

sa is a SQL Server account; if you have users with Sysadmin rights you should be able to just go to properties and set it. I have to change...

Mastermind (3/26/2009)

---

Hi,

I have a task of building a cutomized query builder in .NET. One solution I was proposed is to create one giant view containing around 170 columnsand thousands of...