Viewing 15 posts - 301 through 315 (of 323 total)
You may also want to check that your WAN users are connecting to SQL Server using TCP/IP protocol.
In SQL Server Client Network Utility, make sure TCP/IP is listed first...
June 24, 2004 at 1:53 am
Is there multiple columns or only one big column there, Kanwar?
Can you give an example with the CREATE TABLE so we can see what the column definitions are?
June 24, 2004 at 12:30 am
There;s a number of undocumented features in SQL Server 2000 (that is, they probably wont exist in the next version, so try not to use them!).
There's the master..xp_fileexist extended sproc...
June 24, 2004 at 12:27 am
SQL Server 2000 allows the text, ntext and image data types to hold up to 2GB of data. Because such a huge amount of data can be put in there,...
June 24, 2004 at 12:19 am
Yikes! Keep it simple!
SQL BOL lists:
| Fixed database role | Description |
|---|---|
| db_ddladmin | Can issue ALL DDL, but cannot issue... |
June 22, 2004 at 12:11 am
Or to make sure your SQL Server isn't taken out by an old worm, make sure you have the latest patch SP3a installed
http://www.microsoft.com/sql/downloads/2000/sp3.asp
June 21, 2004 at 6:09 pm
Ouch.
I'm not familiar with Crystal reports, so i'm not sure if you can build a custom form in there or not. Putting the 'change password' in the same front-end app...
June 21, 2004 at 6:04 pm
For reverse deployment I've seen this done a number of places (like taking a copy of live db's and putting them into a dev environment). The only thing that I've...
June 20, 2004 at 11:43 pm
If you are working in a Windows environment, consider using Windows Authentication in SQL Server.
Windows authentication allows users to connect with the windows login credentials, so whenever they change...
June 20, 2004 at 5:34 pm
pwdencrypt is not a documented feature of SQL Server (in other words, don't use it, get some real encryption).
But hey, in anycase, it returns a varbinary result, not a nvarchar...
June 17, 2004 at 1:54 am
checkout the BCP utility in the SQL Server documentation (Books Online).
BCP is a command line program optimised for importing / exporting data from sql server to a text file. BCP is...
June 16, 2004 at 12:16 am
If your procedure is doing a single select statement, you can do it without an IF block:
create procedute sp_abc
@userid int null
AS
SELECT * FROM users WHERE users.userid = @userid OR...
June 16, 2004 at 12:02 am
Grr.. I did a big reply and just lost it.
Yes SQL Server organises the rows inside the data pages in physical order, and with no BOL info to the contrary...
June 9, 2004 at 7:23 pm
Assuming your audit table is going to be continually updated, making a DESCENDING clustered index on date will see SQL Server doing more work; everytime you add a row, SQL...
June 9, 2004 at 12:35 am
David.Poole is right. SQL Sprocs should follow the same sort of logic applied to any programming language. The decision to break something into a subroutine, or separate sproc, should be...
May 21, 2004 at 12:26 am
Viewing 15 posts - 301 through 315 (of 323 total)