Viewing 15 posts - 361 through 375 (of 498 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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
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
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
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....
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
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
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
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...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
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
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
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.