Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
sa be gone!
I don't think you can. The follwoing is from the SQL 2000 books online : "System administrator (sa) is a special login provided for backward compatibility. By default, it is assigned to the sysadmin fixed server role and cannot be changed. Although sa is a built-in administrator login, do...- EdVos
- Post #2
- Forum: Microsoft SQL Server: Setup and Administration
-
Figuring Hardware Setup for Critical Dbase
Try using the system Performance Monitor which supports a number of SQL performance options, including transaction rates, sizes, connections etc. This can be logged to a file at intervals that you specify etc. I have used this a number of times and has been usefull.- EdVos
- Post #3
- Forum: Microsoft SQL Server: Setup and Administration
-
Connection to SQL server failed. Error 1326.
It seems that you are trying to connect via Named Pipes. Check your "client network utility" for correct aliases and that your ole db connection is pointing to the correct server name. Check the protocols supported on your SQL server and that "named pipes" is available. If...- EdVos
- Post #2
- Forum: Microsoft SQL Server: Setup and Administration
-
Searching Files
Try this: set WshShell = WScript.CreateObject("WScript.Shell") Set objFSO = CreateObject("Scripting.FileSystemObject") sDir = <Path to default starting folder> inputfn = inputbox("Enter File Name") set Fldr = objFSO.GetFolder(sDir) set subfldr = Fldr.subfolders... -
Filter on Date Range....
Define a single parameter as "Date" type and check the "Range Value(s)" radio button. Example; if the parameter is called "Period" your formula will be as : {table.invoiceDate} in minimum({?Period}) to Maximum({?Period})- EdVos
- Post #5
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Display a variable's contents for modification
As a reasonble programmer in many other languages, I am trying to write a Qbasic program that will accept many variables input by a user (Text strings). I want to redisplay the data on the screen allowing the user to modify the data without having to rekey the entire
