Seems there is no proper way to do this ...

Thanks for your reply. I will test the possiblity of creating a proc, lets see if it work with no extra permission.

Jobs like SSIS execution etc. can be used...

"inner join on x=Y" should be faster.

GilaMonster (1/25/2010)

---

You can find what filegroup the table is in by querying sys.partitions and sys.data_spaces.

If a table is on a filegroup with multiple files it'll be striped across all the...

The above statement is half true. Its actually allowed, but discourages to be used and you should be extra careful using it, you may end up corrupting your whole sql...

No one interested in discussion !! :doze:

You are getting error while trying to see the history or this is the error logged in job history. Both are different scenarios . Please clarify. I think your job...

I think below link will help

http://www.visualbasicscript.com/m26619.aspx

You have to work around to customize this.

Set the windows login policy for local computer and then make the sql login with enforce password policy (as described in posts above).

SQL Server will take password policy (like...

DBArtisan, Rapid SQL, AquaStudio and several third party tools can be used to administer sql servers of all editions.

We have all these databases running on same instance.

In my opinion, having single databases running on different instances and they all on same server, will decrease the performance...

If possible rebuild the indexes and then update statistics. Or just update statistics will help.

You can get job logs from msdb..sysjobhistory table

Modify the below code with your need

select b.name, run_date, run_time , message from msdb..sysjobhistory a, msdb..sysjobs b

where a.job_id = b.job_id

and...

Also check carefully bootstrap log (like C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG), if you are not getting any error message while installing.

Although not sure about it but default collation for mysql is not English its Swedish. Please check collation of all tools involved (MSSQL, sqlDump and MySQL).

For workaround, you can...