Viewing 15 posts - 1 through 15 (of 265 total)
Hi,
As this is a SQL Server forum you might get better responses in a MySQL forum. It's possible somebody else on here will be able to help you though.
Thanks
September 9, 2020 at 9:50 am
Hi,
Your 'WHERE' statement will go after 'FROM Travel'
Thanks
September 8, 2020 at 11:52 am
That's right, perform an new installation - it will need to be a different instance name from the one you currently have running. Also for security reasons make sure you...
April 30, 2020 at 8:43 am
SQL Server will slowly release the memory back to the OS. Has the memory usage reduced since you posted?
Thanks
November 11, 2019 at 11:02 am
You can still connect to SQL Server 2005 using SSMS 18 so you should come across any problems as far as I'm aware.
Thanks
November 6, 2019 at 9:27 am
That's an easy one to search for yourself, you'll also learn more.
Thanks
November 6, 2019 at 8:48 am
You can use sp_help_revlogin for all your logins and then script out the jobs.
Thanks
November 5, 2019 at 10:30 am
I don't rename the sa account but you can do if you wish. Disabling the account doesn't create any problems as internal processes are still able to use it.
Make sure...
October 9, 2019 at 7:49 am
I set sa as the database owner but I always disable the sa account so there are no problems with security.
Thanks
October 9, 2019 at 7:37 am
I may have misunderstood your question but an instance doesn't have an owner.
Thanks
October 9, 2019 at 7:35 am
If you don't need to do point in time recovery then you may be as well just keeping your daily full backup and putting the database into simple recovery.
Thanks
September 27, 2019 at 9:41 am
There is no point shrinking the log file as it will need to grow again. The only time I would consider shrinking them is if there has been a one...
September 24, 2019 at 2:44 pm
Have you tried putting the database name in square [ ] brackets?
Thanks
August 23, 2019 at 1:22 pm
It gets created during the dbcc checkdb. Did the checkdb complete without any errors?
Thanks
August 20, 2019 at 10:05 am
Viewing 15 posts - 1 through 15 (of 265 total)