Hi, I'm trying to obtain a list of NT Groups that a given NT Username belongs to. The system function IS_MEMBER almost does what I want it to, however, it requires you to pass an NT Group as a parameter and only works on the current user. Somehow though, the function IS_MEMBER is able to […]
2001-10-03
346 reads
2001-09-30
I'm trying to query ntext data from 1 single table. But it seems that the data from the ntext were cutoff. Is there any option settings for ntext in the table level or query or session levels? Thx Ku
2001-09-28
1 reads
I have a VBScript that works fine in standalone mode (It copies Trans logs dumps between SQL servers). Under SQL 2K I created a job and tried to import this script into a job step. When I do so I get the error: The specified file (…) is 3446 characters in size, which is larger […]
2001-09-25
4 reads
Anyone know of alternatives to the following extended procs? They are in 7, but not 2000. master..xp_sqlinventory master..xp_sqlregister
2001-09-21
5 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/rsharma/orphansession1.asp
2001-09-16
6 reads
I'd like to thank and announce Wes (burthold) for agreeing to moderate this forum area. Brian Knight bknight@sqlservercentral.com http://qa.sqlservercentral.com/columnists/bknight
2001-09-10
2 reads
Hello, I have 2 following tables: CREATE TABLE MAIN_TABLE (record_id int PRIMARY KEY,sol_number varchar(7) NOT NULL) INSERT INTO MAIN_TABLE VALUES (1, 681) INSERT INTO MAIN_TABLE VALUES (2, 709) INSERT INTO MAIN_TABLE VALUES (3, 715) INSERT INTO MAIN_TABLE VALUES (4, 716) CREATE TABLE DROPS (drop_id int PRIMARY KEY , rec_id int NOT NULL REFERENCES MAIN_TABLE(record_id), drop_name […]
2001-09-07
2 reads
I have been analyzing Analysis Services for a few months now and really like some of the features that it has. Currently, we use Essbase for OLAP. I was wondering if anybody can give me some insight into the size of the server I would need to support the usage of 200 users (50 concurrently). […]
2001-09-07
2 reads
Does anyone know how add or sub time data types. I have to count how long an employee has been at work that day. He/she can leave or be back at work several times per day. Thanks Mihael
2001-09-06
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers