If this user has his own computer and working on it, why not use HOSTNAME() on trigger, which will give you information from where u get the execution from

Hi

As every one suggested this is a temp storage, if there is a increase in space on temp DB, you ran out...

How about creating a job on SQL agent and schedule it to run on a regular basics 😀

Hi let me make my self clear, are we talking about linked servers, or relationship between tables

Welcome to the club mate, First do you know T-SQL, if not i would suggest to start from there 😀

Hi

Here is a scenario, i attended a Conference on SQL 2008 Nov last year, when we took a poll there were 95% of...

Do you still have a backup for the old tables, on a SQL 2000 Format 🙂

Hi Guys

2 weeks, much extreme, we have got VM on production machine, i have a template that has...

Interesting Question, Search Google, to start with play with sys tables, this should do the trick :D, make sure that you do this in a test environment or may be...

Why cant you give the dates that you have in your system, so customer choose from them , i am using a combo box that contains dates from my database...

i haven't used it, but dosen't it say when you start your SQL management Studio 🙂

Hi Niyala

How are you installing your SQL, are you using a DVD,...

Hi

Check user rights, this might have been changed, if user rights are fine then restore the last restored file, sometimes this weird way works...

Hi

Is there SQL server installed on that machine, if yes then the option will be disabled, if not then select the option to install SQL server...

Create a table on the server and use it on a single Query, that makes this faster(This is not the ideal way of doing it ;)) , this again...