data display in table
hello, i am having a table in which the value of one field is too long, and it isnot being displayed i tried nvarchar, ntext eveything but its not working any new ideas?? thanks in advance
2001-08-13
2 reads
.Net
deny alter table priv - how?
Hi all Im trying to deny the "alter table" command for a schema user. Basically I dont use DBO, the applications in the database get their own userid and create object using it. Ive created the following role to deny schema access but can add to it the "alter table" command to stop developers from […]
2001-07-25
212 reads
Memory
Hello, I've created the alert for Memory-Pages/sec Alert Over 2 in Performance Monitor, I'm getting net send message as Pages\sec is being over 2. I'm confused and what should I do to overcome it. My production server has 523 MB Ram and I've specified SQL Server to use memory dynamically setting max as 440 MB. […]
2001-07-19
8 reads
Aggregating a Set of Hierachical Records
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/lsmith/aggregatingasetofhierachicalrecords.asp
2001-07-09
5 reads
Clonation and the Case of Table Dolly, Part 2
In the last installment of this column, at the end of a long and erudite discussion on clonation, I introduced the sad but instructive story of Dolly. As a real scientist, I was conducting experiments on disconnected data features applied to intermittent applications.
2001-07-03
950 reads
Clonation and the Case of Table Dolly, Part 1
In software, clonation can sometimes turn out to be an extremely helpful technique. More often than not, in fact, you catch yourself duplicating instances of running objects to produce nearly identical objects to be managed codewise in a fairly independent way.
2001-06-13
1,123 reads
Using InterDev's Toolbox
If you've ever played around with the toolbox, you may have discovered one of InterDevs hidden gems. Did you know that the InterDev Toolbox allows you to add you own custom tabs? This feature allows you to access frequently used snippets of code in an instant
2001-04-24
3,051 reads
Blogs
Daily Coping 3 Feb 2023
By Steve Jones
Today’s coping tip is to ask other people about things they’ve enjoyed recently I...
Daily Coping 2 Feb 2023
By Steve Jones
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...
Deadline for Microsoft MVP contributions is 20 March 2023
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
Forums
Coding Magic Values
Comments posted to this topic are about the item Coding Magic Values
How to Check previous data loaded records vs current day in a table
Hello Good Morning, I have three Tables, Assume Table1, Table2, Table3 these three tables...
Permissions Changes Not Doing Anything
Hi friends, So I have a Login to a server that is a windows...
Ask SSC