Viewing 15 posts - 31 through 45 (of 207 total)
When in doubt, normalise. Besides, normalization will help as you expand your project, like say you want to add a table for responses and or possible responses. Provide...
May 14, 2008 at 9:37 am
John is correct, this can be done without the use of backup devices. You can backup the database directly to a local file and then copy that file onto...
May 14, 2008 at 9:01 am
Dana
Using Management Studio, right click on the server, then select Security, in there is the option to select server authentication
May 13, 2008 at 10:29 am
John is correct. It is only a backup of the committed transactions, not the entire LDF. So, back to the original issue, 2 Gigs of committed transactions in...
May 13, 2008 at 6:46 am
Daryl
I've always assumed it was the size of the log file and planned for it to be that way, however, john posted earlier that it wasn't, so I'll have to...
May 12, 2008 at 10:46 am
The SQL Server OU is part of Active Directory, so you have to check with your network admins to get it set up. ONce set up, they should...
May 12, 2008 at 9:56 am
Agree with Steve, collecting 2G of changes in 20 minutes is a heck of a throughput. What I suspect is that your log file size is already 2Gs and...
May 12, 2008 at 9:16 am
In SQL Server, all jobs are run based on the credentials of the account that the SQL Server agent is signed in as.
When you developed your package, you...
May 12, 2008 at 8:51 am
In the full mode, log files grow until backed up and once the file has grown it does not resize as SQL Server automatically assumes that the current size of...
May 12, 2008 at 8:38 am
I don't think it's a best practice to restart SQL server unless you are having some type of issue with resources, such as the tempdb becoming too large and must...
May 12, 2008 at 8:31 am
The witness server serves as sort of a tiebreak vote to decide which server is the primary. Without it it's like Gore/Bush, the server's won't know who won the...
May 12, 2008 at 8:27 am
There is actually no difference to set up an AD account in the database to a SQL Login when it comes to groups/roles.
Hopefully you were given rights to...
May 12, 2008 at 8:07 am
Definately not a missing table. Remember the * bring back all objects not just tables. My money is either a Stored Proc or ufn
May 9, 2008 at 5:41 pm
Just remember to let us know how this works out. Also, besides, company, I want to know the Director of IT or whomever is over the programming there. ...
May 9, 2008 at 5:38 pm
If you are dedicated to the SQL Server craft then you will find that it becomes easier each day. You can not learn it all at once, in fact,...
May 9, 2008 at 1:03 pm
Viewing 15 posts - 31 through 45 (of 207 total)