Viewing 15 posts - 29,041 through 29,055 (of 39,771 total)
From what I've heard, the same features in 2005 Standard will be there in 2008 standard. The document, however, is misleading.
April 2, 2008 at 6:30 am
There isn't a good way to do this. If people have Enterprise Manager and a login, they can look at the tables in the database.
Why can't they see the columns?
April 1, 2008 at 4:08 pm
By timestamp do you mean the date and time of the last transaction? Wouldn't it be the timestamp on the file?
April 1, 2008 at 4:08 pm
Search here in the scripts section. There are lots of backup scripts that can probably do this.
Note that they will require the xp_cmdshell for the most part, and that's not...
April 1, 2008 at 4:04 pm
I'm not as concerned about SQL Server on a VM. I have friends doing it and it can be done, but you have to understand it's a shared resource. First...
April 1, 2008 at 4:01 pm
Yes you should do it and if there are errors, you need to be alerted. most of the time errors are hardware problems and you need to fix them.
I don't...
April 1, 2008 at 9:19 am
A "hot backup" usually means taking a backup without shutting down the server. When you run a backup in SQL Server, it's a hot backup. A "warm backup" typically means...
April 1, 2008 at 9:18 am
SSPI is a security error with Windows Auth. It can be a number of things. Try these links:
support.microsoft.com/kb/811889
April 1, 2008 at 9:16 am
It's April Fool's, but it's a good idea. Who wouldn't like a HALO or Gears of War game tarketing Oracle DBAs or databases!!!
Don't forget to play some jokes on those...
April 1, 2008 at 9:15 am
Remember if you run this from your SSMS, it'son the server, it's the server path, NOT your workstation path. You can't get to your workstation path from a server, unless...
April 1, 2008 at 9:14 am
Michael is right, but I'd also think about separating the logs from the data onto separate spindles (logs - sequential access, data-random), or even tempdb onto separate spindles since it's...
April 1, 2008 at 9:13 am
note that you need to ORDER BY this identity column to get rows back in numerical order. By default SQL Server does not guarantee row ordering, regardless of what order...
April 1, 2008 at 9:11 am
I can't find that error in a search, but you might try running this from the command line (VBScript) and see if there's a better error returned.
April 1, 2008 at 9:01 am
I know everyone is busy, but voting helps authors. It's a second to vote on an article.
A "good job" or "nice article" goes a long way as well. You don't...
April 1, 2008 at 8:58 am
Viewing 15 posts - 29,041 through 29,055 (of 39,771 total)