Viewing 15 posts - 406 through 420 (of 1,655 total)
The easiest way would be scheuling a profiler trace.
Since you can't schedule it directly from profiler you have to take a few extra steps.
1. Define your trace in profiler and...
April 15, 2009 at 5:28 am
Lian Pretorius (3/30/2009)
I would assume:When the job starts - Users are disconnected & the restore job is the only process connected to the database (Single User).
Unless you rewrite the restore...
April 15, 2009 at 5:13 am
You can download it in pdf format from MS.
April 15, 2009 at 5:07 am
shivageography (4/15/2009)
Hi,while my primary server is down i made up my secondary server then how can i transfer job scheduling as well as logins and users.
Once you're primary server...
April 15, 2009 at 2:41 am
Vijaya Kadiyala (4/9/2009)
Vivek (4/9/2009)
hican any one tell me how database level caching can be implemented in sql server.
You can't cache a database..Caching is at the table level.
Check out the...
April 9, 2009 at 8:45 am
You cannot alter the expiration date of the existing ceritficates. You need to replace these certificates with new ones.
1. Create a new certificate on server1
2. Backup the public key of...
April 9, 2009 at 4:52 am
This should help:
http://msdn.microsoft.com/en-us/library/ms403426(SQL.90).aspx
April 9, 2009 at 3:58 am
VmWare has several free products you can download.Not sure which will run on Windows XP but you should be able to find that info on their site. http://www.vmware.com/
As an alternative...
April 8, 2009 at 12:54 am
Create the login without adding any database access, then run sp_change_users_login with the Update_One option to link the existing database user to the new login.
April 8, 2009 at 12:50 am
That's the same version as I have and it works for me.
No idea what's different with your installation.
April 7, 2009 at 7:40 am
Could it be that you're using Management Studio Express? On my SSMS 2008 it's just like I told you before.
April 7, 2009 at 6:35 am
Edwin (4/7/2009)
Hi Room,I have a silly question on SQL 2008 solution explorer.
Where can I find the SQL 2008 solution explorer?
On SQL 2005. The Solution Explorer located under VIEW menu.
Thanks,
Edwin
It's the...
April 7, 2009 at 6:07 am
Try this:
SELCT Col1, col2, col3 from table1
UNION ALL
SELCT Col1, col2, col3 from table2
April 7, 2009 at 3:57 am
It would really help if you would tell us what technology you use for updatig your standby server.
Is it logshipping? Then restore the last backup using the RECOVERY option.
Is it...
April 7, 2009 at 2:51 am
I don't think you can setup a failover cluster between your desktop and your laptop, but there is a good whitepaper about setting up a failover cluster between two virtual...
April 6, 2009 at 7:14 am
Viewing 15 posts - 406 through 420 (of 1,655 total)