Rating Thread / Thread Starter	Last Post	Replies	Views
"simple" security? I've heard that SQL Server's security system is good, but complicated. What is the easiest way to: 1. Limit who can make structural changes to the... Paul Pedersen	06-14-2005 03:11 AM Paul Pedersen	3	47
unable to create a recordset in vb6 from stored procedure I am having problems opening a recordset in my vb6 program from the following procedure i get "operation is not allowed when the object is closed" I... steven scaife	06-14-2005 03:11 AM steven scaife	5	43
Inner Join Hi all I have some confusion amoung the joins in SQL Server I have two tables TableOne - having 2 records , id as primary key (1, 2) TableTwo -... sajeev.padmanabhan@gmail.com	06-14-2005 02:58 AM sajeev.padmanabhan@gmail.com	4	36
Help, Mr. Wizard! I did a bad, bad thing. I set my default database to some database, then I detached it. Now I can no longer log in to SQL Server to reattach... Paul Pedersen	06-14-2005 02:42 AM Paul Pedersen	5	48
SQL DMO Is there a way to find out if a SQL job was completed successfully using SQL DMO? I want to use VBScript to do this. Thanks! Ken	06-14-2005 02:00 AM Christian Donner	2	53
Complex Task Execution Time Hello All, I have quite a complex task that needs to be run every 12 hours. The totals tasks TSQL extends beyond the 14000 line mark with several... Anubis	06-14-2005 01:59 AM Brian Selzer	4	35
Create 1 column of query results from 2 table fields Hi. Can anyone suggest how I could create 1 column of results from 2 fields of a table? What I am trying to do is create 1 dropdown list that... Amy	06-14-2005 01:53 AM John Bell	5	32
BizRule implementation I have a table with follwoing feilds: 1)ClientID 2)EmailAddress 3)AddressDescription 4)Primary 5)BizRuleFlag there could be multiple address for... J-T	06-14-2005 01:40 AM John Bell	4	37
Trigger question Hi, I have a table with 21 columns, and have a couple of update triggers. One trigger updates two columns (lets call them Tom and Jerry) which are... Andy	06-13-2005 09:47 PM Brian Selzer	3	51
join and aggregate values, any suggestions? Note: this is for my use, not a project I am doing for someone else. I am not trying to get the SQL Community to solve my consulting problems. I... Matthew Speed	06-13-2005 09:43 PM --CELKO--	3	30
What Recovery Mode? I have 150+ DBs on a single instance. Rahter than me going through each server's properties to find out its recovery mode, is there any easier way... Rob	06-13-2005 08:49 PM Stefan Berglund	5	56
store result of EXEC fnction to local variable Hello: Is there a way to store the result of an execute function to a local variable? From an extract of my code below, I'd like to store the... Rob	06-13-2005 08:30 PM Steve Kass	4	37
NOT IN query with more than 1 field ( 1 2 ) I have a Customer table located in 2 different database (say db1 and db2). The Customer table at db1 has 1 additional field, although the records... wrytat	06-13-2005 08:17 PM wrytat	12	52
Need-a-Guru: Gaps in Sequences - Part II Hi all, thanks for all the help with the previous problem. Now I have the proper results and everything is working perfectly. But now I have a... Michael C#	06-13-2005 08:14 PM Michael C#	4	30
Are 'inserted' and 'deleted' tables or views? How are 'inserted' and 'deleted' implemented by SQL Server? When I look at the execution plan of a trigger that selects from 'inserted', I can see... BGL	06-13-2005 08:14 PM Eric Sabine	9	74
Finding Orphaned Records : Can you suggest a better algorithm? : SQL 2000 /* Is there a cleaner/better/faster way to do this? Do I need to use Table Variables? I am cleaning up an SQL 2000 database, it has Inventory Items... Russell Mangel	06-13-2005 08:06 PM Russell Mangel	7	35
unabiguous date constant '08/02/2005' might mean Auguest 2 2005 or February 8 2005, depending on some setting somewhere. Does SQL Server recognize any format as an... Paul Pedersen	06-13-2005 07:12 PM Paul Pedersen	9	34
DTS package modification with VB If I open my DTS pkg in Designer, and then save it as a .bas file to modify it, how can I bring it back in to DTS "Local Packages" in Enterprise... Kathy	06-13-2005 04:42 PM David Portas	1	31
Unsupport value for SCALE! creating view from an Informix linked server FACTOR-JACO is an Informix linked server -------- Create View vw_FA_dailySales as SELECT * from FACTOR_JACO..ssfactor.sales100 go Got this error... Bill Nguyen	06-13-2005 04:35 PM oj	1	75
SP to list all members of a certain NT group... Hi All, I'm using windows authenitication for all my sql servers. I have a lot of NT groups that contain a lot of uers and sometime I don't remember... tom d	06-13-2005 04:30 PM oj	2	29
SQL Statement Help Hi All, I have three tables (for simplicity, I'll include only mock data): Table A: Brian Piotrowski	06-13-2005 04:19 PM oj	1	40
How to find connection options We have a web app that is demonstrating bizarre performance issues, but most of the work is all in stored procedures. The Web App, when the user... Mike Labosh	06-13-2005 03:47 PM Mike Labosh	2	36
Phonetic algorithm ? Hi, I have a table to city names which I need to do a select and return rows which contains values which is almost like a provided value, i.e a... Netveloper	06-13-2005 03:36 PM Ross Presser	6	42
Raising SQL errors I am building an asp.net website which uses a SQL Server database. I want to do data validation in the stored procedures and triggers, and raise... Craig HB	06-13-2005 03:25 PM pdxJaxon	3	36
Updating numerous users in Stored Procedure I have the following stored procedure how can i update more than just one at a time. Example if I have 2 users 2344 and 3424. Create Procedure... Lontae Jones	06-13-2005 03:23 PM RayG	1	31
Creating large strings I am trying to create a string that will be usind in an IN clause. The string can become very large, easily outgrowing the size of a... Chris Lieb	06-13-2005 02:09 PM Chris Lieb	8	35
enterprise manager scripts Someone once told me how to get the Enterprise Manager to display the commands it's executing when you tell it to do something via a menu or similar... Paul Pedersen	06-13-2005 12:50 PM John Bell	2	33
Descriptive locations? Hi all, Are there any standard locations for descriptive information about a database and about a table that are easily accessible in EM? For... John Spiegel	06-13-2005 12:24 PM John Spiegel	2	33
Table variable in Dynamic Sql I have created a table variable and i want to use it in a Dynamic Sql Statement.(Before I created a temporary table.but becase of performance issues... Vinoth Nivas J	06-13-2005 12:11 PM John Bell	6	32
Primary Key, bigint or char? ( 1 2 ) Hey guys, just a quick question for you. I think I know the answer, but I would like to get the expert's opinions... I have a primary key called... Tim Baur	06-13-2005 11:58 AM --CELKO--	13	68
HOW TO: store result of EXEC fn to local variable Hello: I'd like to store the result of a execute function to a local variable, as shown in the code extract below: ::::::::::::::: OPEN... Rob	06-13-2005 11:55 AM Rob	1	31
Multiple Items Updated using Replace I am doing a global search and replace on a text field using this query I found (see below) It works great but I have multiple search and replaces to... Brian	06-13-2005 11:36 AM --CELKO--	1	30
Conditional cascase delete Is their any way in SQL 2K to specify a condition for allowing cascade deletes on a foeign key constraint. For example based on the value of a field... hals_left	06-13-2005 10:25 AM --CELKO--	2	36
how to identify the newly inserted rows in a table? hi all, I have a table without auto-generated ID nor time stamp. I want to identify the newly inserted rows in a table. I can't make any... Ahmed	06-13-2005 10:15 AM --CELKO--	8	34
Need help with slow running query ( 1 2 ) I have an ugly query that is left joining a parent table with multiple children tables. The actual query runs slowly in Query Analyzer (QA) e.g. 3... Need more Zzzz	06-13-2005 10:14 AM Anith Sen	13	64
long SQL View formula I have been migrating an MDB to SQL and have had to rewrite many of the queries into SQL Views. The problem I am having is that SQL doesn't seem... Stephen	06-13-2005 10:10 AM --CELKO--	4	39
distinct I want to select the distinct customer ID records, yet include all the other fields... Is this the correct syntax? "SELECT... M.Smith	06-13-2005 10:08 AM David Portas	8	45
Difficult Group By Clause Hello All, I have come across an issue that I am struggling to find a solution for. I will do my best to explain the situation below: I have 2... Anubis	06-13-2005 09:57 AM Ross Presser	5	36
How to programmatically count number of connections? Hey all, specific database)? Thanks much, Roy roy.anderson@gmail.com	06-13-2005 09:14 AM Jacco Schalkwijk	2	41
bcp utility - columns names hi, I'm using bcp utility in order to copy data from SQL table into an excel file & txt file. It works fine and copy the data, however I also need a... A	06-13-2005 09:06 AM JosephPruiett	3	40
Trimming control characters Hello! Suppose the contents of a field from a table is stored in e variable of type VARCHAR(10). DECLARE @A VARCHAR(10) ggeshev	06-13-2005 09:06 AM Mike Epprecht \(SQL MVP\)	5	37
OLEDBProviderInfos vs Connections I have two questions: 1) Why aren't the available DTS providers (connection Icons in Designer) listed in the OLEDBProviderInfos collection of the... toryb	06-13-2005 08:59 AM toryb	0	30
Moving from Tempory Tables to Table variables, what are the impact Hi, Thinking of stopping the use of Tempory tables and starting to use Table variables instead. Where are the object created and logging done ?... Al	06-13-2005 08:59 AM JosephPruiett	3	33
how to use function in view ? Hi, I have a problem that I can't solve Table 1 idProduct, labelProduct Table 2 idProduct, purchaseDate, purchasePrice jack	06-13-2005 08:31 AM jack	4	37
SQL Server Mail box - xp_readmail Hi, I executed xp_readmail stored procedure. It brought some records as result. I do not know from where it brought those records. Those were not... Sevugan	06-13-2005 07:25 AM Sevugan	4	36
Updating one field with another in the same table Hi, I am trying to update the data in one field with that of another field in the same table, I think I am going about it in a long wined way. Both... Robert	06-13-2005 07:00 AM Dhericean	2	36
dropping a table on a linked server ( 1 2 ) What is the SQL for dropping a table on a linked server? Using: DROP TABLE LINKEDSERVERNAME..USER..TABLENAME doesn't work.	06-13-2005 06:34 AM	11	80
How to enforce integrity across databases I would like to enforce integrity across two databases on the same server. As far as I know there is no way to create a FK constraint pointing to... DBA72	06-13-2005 05:50 AM DBA72	3	53
current user Hi All, I am trying to create a trigger on a table to insert a record into another table based on the current users name that is logged on. I tried... jaylou	06-13-2005 05:48 AM jaylou	4	43
select from stored procedure? Hi anyone/everyone I desperately need help. I have created a stored procedure to build all the dates between two dates. i.e. the procedure picks up... Chan	06-13-2005 05:02 AM Christian Donner	2	42

Page 903 of 1545

903

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off