Viewing 15 posts - 361 through 375 (of 497 total)
What you need to do is called a "Pivot Table Query"(in Access it is called a Cross Tab Query). If you look in Books Online for "Cross Tab Reports" you...
October 8, 2003 at 3:26 pm
Well here is what I do if I want to shrink my database.
BACKUP LOG <DBName> TO <LogBackupDevice> WITH Stats, NOINIT
BACKUP LOG <DBName> WITH TRUNCATE_ONLY
DBCC SHRINKDATABASE(<DBName>)
BACKUP...
October 8, 2003 at 2:59 pm
Matt,
Sorry for the delayed response. I'm extremely busy lately trying to implement a new database design. I have no experience with any of the academic versions nor the personal edition...
October 8, 2003 at 2:40 pm
Matt,
I've never used the Academic version although I would be very surprised if it were different in this area. As for what security settings are needed I have not looked...
October 2, 2003 at 6:03 pm
If you make the Server Explorer visible you should be able to set up a connection to the server. I always use the C++ environment but it should be the...
October 1, 2003 at 6:19 pm
The account would be a windows account. The problem is that your system account doesn't have the ability to see the IPC network share. If you right click on "My...
October 1, 2003 at 6:16 pm
Andy,
At this point I just don't have time to get the legal stuff I would need to have done to do that. Plus I believe there is already one on...
October 1, 2003 at 6:08 pm
Try this one...
EXEC master.dbo.xp_cmdshell 'DIR C:\ /b'
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
October 1, 2003 at 5:58 pm
DTS Allows two way transfers and one small mouse click could easily destroy the database. Thus on my systems I don't allow something like that if I can help it....
October 1, 2003 at 5:52 pm
Did you look at the License.txt file on your CD?
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
October 1, 2003 at 5:01 pm
As usual Andy, you have done a wonderful job writing your article! One of the first things I did when I got hired here was to create a SQL Best...
October 1, 2003 at 4:44 pm
I use the VS.Net IDE to edit all my SP's. I simply create a database project and then add connections to the Server Explorer window. I probably have 25 database...
October 1, 2003 at 4:25 pm
Hey Keith,
Wouldn't you want to use FOR XML EXPLICIT with your sql rather than AUTO?
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
October 1, 2003 at 4:19 pm
You can use OpenDataSource to update an XLS file provided the XLS worksheet is shared and you have "Field Names" at the top of every column.