dbTalk Databases Forums  

Sponsored Links


microsoft.public.sqlserver.programming microsoft.public.sqlserver.programming


Discuss in the microsoft.public.sqlserver.programming forum.



Post New Thread
Threads in Forum : microsoft.public.sqlserver.programming Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
I found this procedure on the internet and choose to share it here. It ll locate any text string inside each procedure or scalar function. (you can...
André Freitas
08-09-2009 08:17 PM
Dan Guzman Go to last post
1 94
Hi All I have an existing CLR stored procedure on Sql Server Express 2005 which has 4 parameters I need to alter the procedure to add 2 more...
Steve
08-08-2009 08:41 PM
Steve Go to last post
2 87
Hi, I have a set of tables that I will be dropping some FKs and NC indexes then loading some data and then recreating the table objects. Is there a...
Jerry
08-08-2009 11:21 AM
Sualeh Fatehi Go to last post
3 98
I'm not actually sure where the problem lies, so please bear with me. I'm using MS LogParser V2.2, to read events from an event log, and I want...
Charles
08-08-2009 10:03 AM
Jeremy A. Holovacs Go to last post
17 173
I've got a DB where some tables have columns that require localization and I'm trying to find what's the best way to handle this. For instance, in my...
Mike
08-08-2009 07:32 AM
Mike Go to last post
5 98
I have a query which is inserting records from another table which holds imports from another database. Sometimes I get errors on primary...
Rich Lawson
08-07-2009 05:31 PM
Rich Lawson Go to last post
6 83
Hello, I need to a have a column in query that is a string but looks like a number, The value would be something like "200,000 caps", where the...
Don
08-07-2009 04:49 PM
Aaron Bertrand [SQL Server MVP] Go to last post
1 87
Hi all - Just trying to understand why this might be so slow. Takes 30 secs to run (returning 165 rows). Takes < 1 sec to run if I remove...
shawn@adova.com
08-07-2009 03:03 PM
shawn@adova.com Go to last post
4 85
I'm trying to generate reports in Excel off a series of csv files generated from ad hoc queries in SQL Web Admin query analyzer. I need to get the...
.Net Sports
08-07-2009 12:10 PM
Aaron Bertrand [SQL Server MVP] Go to last post
1 94
Ok. So this is where I am at: DECLARE @GenNum INT SET @GenNum = (SELECT TOP 1 fldNumber from tblTable WHERE fldInUse IS NULL ORDER BY...
DCHOBO
08-07-2009 11:09 AM
--CELKO-- Go to last post
10 137
Hello, I have a database named as 'Cellar duty'. Means, a database name with a space in between two words. When I run sp_msforeachdb in the...
Abba
08-07-2009 10:39 AM
--CELKO-- Go to last post
5 98
I am using SQL Server 2005. I am selecting numbers from a column based on a numtype and another column numtypeII. If the numtype in A, D...
gh
08-07-2009 10:30 AM
--CELKO-- Go to last post
2 87
I have a table that includes 2 fields, Month and IsLastOccuring, like this : Month IsLastOccuring 1 No 2 No 3 No 4 No 5 ...
Mike P
08-07-2009 10:03 AM
--CELKO-- Go to last post
3 102
I have a sql table which contain three columns: OrderNo, Code, and Modifier. I need to to exclude orderNo which contain code A with Modifier 1, code...
qjlee
08-07-2009 09:35 AM
Plamen Ratchev Go to last post
1 117
Hi, I basically have the following code select a.x, a.y, b.* from A as a left join B as b on a.x= b.x order by a.x, a.y
Michael
08-07-2009 01:29 AM
Carlos Sacristan Go to last post
9 104
Hi, I am running SQL Server 2008 Enterprise (64-Bit), on Windows 2008 Standard Server (64-Bit). Lastest service packs. The hardware isn't much,...
Russell Mangel
08-06-2009 10:57 PM
Jeremy A. Holovacs Go to last post
4 118
Hello, I am creating a few Stored Procedures after some tables and I always get the following errors: Incorrect syntax near the keyword...
shapper
08-06-2009 10:47 PM
Jeremy A. Holovacs Go to last post
7 105
Hi, I have three tables A,B,C that I am joining in 1 Query. Table A (Province Names) having matching record in other Tables B and C (B & C always...
M.K
08-06-2009 10:18 PM
M.K Go to last post
4 109
Hi, After executing a select command I execute statements below: Select @@RowCount if @@RowCount = 0 Select 'ONE'
Kursat
08-06-2009 09:25 PM
Jeremy A. Holovacs Go to last post
3 98
Hi I have the following Table X Y Z 1 2 3 1 3 4 1 4 5 1 5 7 1 6 9
Michael
08-06-2009 07:45 PM
Michael Go to last post
4 89
Hello all, I've ran across into a wierd dielma. I have a file that I sent over to another dept that gets a CSV file from our SQL server on a monthly...
altor77
08-06-2009 05:23 PM
altor77 via SQLMonster.com Go to last post
5 106
I have seen tons of things out there telling oyu to rollback a transaction in the catch block of a trigger, capture the error information and write...
John Couch
08-06-2009 05:21 PM
Erland Sommarskog Go to last post
12 140
Is it possible to change the server you are connected to through T-SQL? If so, how? I want to run queries against specific servers so that it will...
Rubens
08-06-2009 01:43 PM
Rubens Go to last post
9 113
For Error: Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. Suggestion1 from the...
AAaron123
08-06-2009 12:58 PM
AAaron123 Go to last post
5 87
Why do you change the direction of the topic? What Tony was saying was that not a lot has been taken away. If I wrote code in 6.5, how does...
Jason R. Soby
08-06-2009 09:19 AM
Aaron Bertrand [SQL Server MVP] Go to last post
39 283
Hello, I came across a useful script, in http://www.mssqltips.com/tip.asp?tip=1510, that determines free space on data file level. I would like to...
Abba
08-06-2009 09:07 AM
Abba Go to last post
5 92
Hi, I have an empty table which is as follows: plant machine plan_date plan_hrs plant and machine are varchar plan_date is datetime and plan_hrs is...
Jack
08-06-2009 08:47 AM
Jack Go to last post
2 118
Hello, Is there any setting whereby the database connection would disconnect itself automatically after a script has been executed? For example, I...
Abba
08-06-2009 01:52 AM
Abba Go to last post
8 138
Hi, I have a table as follows. X 5 6 9 12
Michael
08-05-2009 08:18 PM
--CELKO-- Go to last post
5 139
Hi, I'm implementing the auto suggest feature in my ASP.NET application that makes suggestions for products as the user types the product name....
Sam
08-05-2009 05:12 PM
Jeremy A. Holovacs Go to last post
2 126
Hello, I got a problem with the Batch Separator: I wrote the following code: USE DBTEST GO CREATE Type .....
Rick
08-05-2009 04:52 PM
Erland Sommarskog Go to last post
4 94
We are starting to get a lot of deadlocking on one of our (2000) servers in the early am hours. We are going to the traceon's to hopefully capture...
CLM
08-05-2009 03:00 PM
CLM Go to last post
5 121
Hello, I am creating the following tables: create table dbo.Groups ( Id uniqueidentifier not null rowguidcol constraint PK_Group primary key...
shapper
08-05-2009 01:53 PM
Aaron Bertrand [SQL Server MVP] Go to last post
6 114
I have a job that runs a dts package in which executes Stored Procedures. I am trying to optimize some of the SPs and want to know if I can put in...
Chris
08-05-2009 10:58 AM
Tibor Karaszi Go to last post
3 112
I am making a Testimonials application. The database requirements say that a row must be randomly selected. On top of this, all of the rows from...
Andy B.
08-05-2009 10:01 AM
Plamen Ratchev Go to last post
3 84
I have data as follows field0 Fields1 A 10 B 20 C 30 Now I want to...
Navin
08-05-2009 09:25 AM
Uri Dimant Go to last post
1 122
Hi, I have a table A X Y 1 2 1 3 1 5 a table B
Michael
08-05-2009 09:21 AM
Plamen Ratchev Go to last post
4 94
Hello! I need to insert 4MM records into a table that contains 7MM records (same table structure), with a logic of ID = Id+1 on every new...
Test Test
08-05-2009 09:11 AM
Test Test Go to last post
5 103
Postgres windowing functions http://www.osdbzine.net/osdbzine_issue1.pdf Postgres window...
steve dassin
08-05-2009 08:45 AM
Aaron Bertrand [SQL Server MVP] Go to last post
3 86
Hi CREATE TABLE TableA (x INT PRIMARY KEY); INSERT INTO TableA (x) SELECT number FROM master..spt_values WHERE type = 'P' AND number BETWEEN 1 AND...
Michael
08-05-2009 08:19 AM
Plamen Ratchev Go to last post
8 113
Before I attempt it I was wondering if I can use a DDL trigger to deny altering a stored procedure. Would a test on the username and the RETURN...
Chris
08-05-2009 08:02 AM
Chris Go to last post
3 88
Hi All how Can i Change the column Length with ALTER TABLE Tankes
taha105
08-05-2009 03:51 AM
taha105 Go to last post
2 101
Hi, create table tmp1 ( a int, b int ) insert into tmp1 (a, b) values (2, 10)
Michael
08-05-2009 02:29 AM
Erland Sommarskog Go to last post
5 90
Hi, When I have the Create table in a Stored proc, the default user is the userid of the person logged in but when I go to drop the table, it...
Ellie
08-05-2009 02:23 AM
Erland Sommarskog Go to last post
5 110
Hi, I have a table like the following: X Y 1 1 1 7 1 5 1 9 2 2
Michael
08-04-2009 08:24 PM
Linchi Shea Go to last post
1 98
I have a column named 'img' for images, and i need to assign the names of the images with the names of the associated entry # 'eno' and concatenate...
.Net Sports
08-04-2009 06:47 PM
.Net Sports Go to last post
6 91
I have a SQL Server 2005 database that I saved in XML format in a text field. I would like a SQL Server function or script to determine if the value...
Joe K.
08-04-2009 05:42 PM
Erland Sommarskog Go to last post
3 102
Hello, I have the following: create table dbo.Roles ( Id uniqueidentifier rowguidcol not null constraint DF_Role_Id default (newid()), ...
shapper
08-04-2009 05:14 PM
Aaron Bertrand [SQL Server MVP] Go to last post
4 80
Here's the task: 1. A table has components 2. Each component has layers Sample: COKEY ..fields.. CHKEY | SOL_K1 | SOL_BD1 | SOL_...n row1 ...
Marilyn
08-04-2009 05:12 PM
Marilyn Go to last post
4 105
Hello, I have 3 tables: Posts, Tags and PostsTags. - When a Post is deleted I need to: Delete all PostsTags related to it. No record in Tags should...
shapper
08-04-2009 04:58 PM
Hugo Kornelis Go to last post
1 92
Post New Thread

Display Options
Showing threads 3251 to 3300 of 69251
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread 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


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.