Viewing 15 posts - 301 through 315 (of 379 total)
If you use NBTSTAT with the -RR parameter, it will do a release and refresh. If you use NBTSTAT with the -R parameter, it will purge the contents of...
All the best,
Dale
Author: An Introduction to SQL Server 2005 Management Studio
July 14, 2003 at 10:42 am
Frank,
Check this out. I found this on Citeseer. Used that site a lot for my Masters:
http://citeseer.nj.nec.com/wolfson98moving.html
Select from the cached links on the upper right (i.e., PDF format).
All the...
All the best,
Dale
Author: An Introduction to SQL Server 2005 Management Studio
July 14, 2003 at 10:21 am
Make sure that name resolution (NetBios or DNS) is not the problem. Does the client connect using a host name vs. the actual IP address? If so, try...
All the best,
Dale
Author: An Introduction to SQL Server 2005 Management Studio
July 14, 2003 at 10:03 am
Put the user in a database role that doesn't have db_owner or db_ddladmin priviledges (i.e., put them in the "public" role assuming that you have not GRANT rights under "public"...
All the best,
Dale
Author: An Introduction to SQL Server 2005 Management Studio
July 14, 2003 at 8:48 am
Frank,
This may be what you are looking for:
quote:
Estimating the Size of a TableThe following steps can be used to estimate the amount...
All the best,
Dale
Author: An Introduction to SQL Server 2005 Management Studio
July 14, 2003 at 7:58 am
Frank,
Are you just looking for the maximum size per row or are you actually wanting a measurement for each row?
All the best,
Dale
All the best,
Dale
Author: An Introduction to SQL Server 2005 Management Studio
July 14, 2003 at 7:45 am
Try this checklist (found at http://www.kempscaseworks.com/SUPPORT/SUPPORTLIBRARY/SQL/SQLInstall.htm#_Toc519050991:
When it "locks up" can you connect at all to SQL Server? Try connecting locally on the server using ISQL.EXE - ISQL -Usa -P<pwd> and...
All the best,
Dale
Author: An Introduction to SQL Server 2005 Management Studio
July 14, 2003 at 7:37 am
After you have selected the MS Access table to copy into your SQL Server, you will come to a screen that says "Select Source Tables and Views". When you...
All the best,
Dale
Author: An Introduction to SQL Server 2005 Management Studio
July 14, 2003 at 7:30 am
You can also customize the toolbar to run applications like Notepad. I did this for Textpad. Didn't mention this before 'cause I didn't think that was what you...
All the best,
Dale
Author: An Introduction to SQL Server 2005 Management Studio
July 12, 2003 at 7:49 am
This topic has already been answered under another thread.
All the best,
Dale
Author: An Introduction to SQL Server 2005 Management Studio
July 11, 2003 at 2:38 pm
You can use the isqlw utility from within Query Analyzer.
isqlw -d pubs -E -f "c:\Program Files\Microsoft SQL Server\MSSQL\Install\instpubs.sql"
All the best,
Dale
All the best,
Dale
Author: An Introduction to SQL Server 2005 Management Studio
July 11, 2003 at 2:36 pm
I hope I'm on the right track here for you. When you do the export, in the screen that says "Select Objects to Copy", you have to uncheck "Copy...
All the best,
Dale
Author: An Introduction to SQL Server 2005 Management Studio
July 11, 2003 at 2:08 pm
Well, I'll try to answer your question. Here are some things that you can't do with views (not necessarily arguments):
- Can't use the ORDER BY clause (can use with...
All the best,
Dale
Author: An Introduction to SQL Server 2005 Management Studio
July 11, 2003 at 1:39 pm
One last thought. I don't want to steer everybody helter skelter. Have you installed Desktop Engine SP3a?
http://www.microsoft.com/sql/downloads/default.asp
All the best,
Dale
Edited by - dalec on 07/11/2003 1:04:16 PM
All the best,
Dale
Author: An Introduction to SQL Server 2005 Management Studio
July 11, 2003 at 1:04 pm
I hope I'm not throwing things way off base here but I just found this. It seemed weird enough to mention:
quote:
I...
All the best,
Dale
Author: An Introduction to SQL Server 2005 Management Studio
July 11, 2003 at 12:57 pm
Viewing 15 posts - 301 through 315 (of 379 total)