TheMSsForum.com: The Microsoft Software Forum

TheMSsForum.com

view full version: back to formated view
1: I need to add an addtional table\field to this Stored Procedure...
2: help on trigger question - after update and after insert
3: NT Event Log
4: SQL JOIN query help
5: Exporting Stored Procedure Results w/ SSIS?
6: Conditional Joins Syntax Help
7: Rows affected?
8: Read Only Joined Recordsets
9: Backup file and filesgroups
10: view with hash joins - strange performance issue
11: How to copy operation tables to test tables ?
12: SQLDMO - Create a folder?
13: 8152 - String or binary data would be truncated.
14: Problem in writing in file
15: tools for SQL Server programming Upgrading backend from
16: Consolidate datafiles to one drive
17: Determining resultset column definitions for stored procedures.
18: Script all object in a DB from a script
19: Calculate Power
20: SSIS
21: RULE
22: How to use variable with the USE statement
23: access 2003 in the front and sql server 2005 in the
24: bcp syntax help
25: Identify hidden stored procedures
26: Why is it complaining about my Syntax?
27: Remove Seconds from DateTime in SQL 2005
28: Auto-recovery information in SSMS
29: Update Cube on NonLeafMembers
30: Truncated parameter to nested procedures
31: a union query
32: Warehouse Design
33: Sequential ID That Resets Each Day
34: Filestream access denied error SQL 2008
35: ExecuteNonQuery insert how to tell what identity field was created
36: Memory consumption question
37: How to find all instances of an expression or statement in database?
38: How to continue with inserts if violate unique index
39: DateTimeForamts
40: Linked server 64 bit SQL SERVER - 32 bit sybase
41: SQL 2005 and SQL 2008 File Comptibility
42: Conversion failed when converting from a character string to uniqueidentifier.
43: Testing for NULL in CASE statement
44: Debugging a stored procedure
45: SSIS: Connecting to Oracle destination in Data Flow task
46: SqlDumpExceptionHandler: Process 56 generated fatal exception c000
47: Obtain a Lock on records with select
48: Step by Step SQL Server Express Set Up project.
49: Re-Gen all numbers in the PK field
50: IDENTITY
51: To find users permission on SP
52: Grab the last value in the identity field and ReSeed
53: SQL query puzzle
54: SSMS - How to Automatically Connect on Startup
55: I need help with a couple query issues, please
56: Errors for Bulk Insert
57: Select Max
58: How can I do this...
59: Question on user defined function
60: Case sensitivity in views
61: Sql Server 2005: VarBinary/Image will not store more than 8000
62: formatting ntext field
63: SQL7 performance
64: Database backup
65: VB6 app upsized from Access to SQL Server 2008
66: Response truncated when run as job
67: dateadd and conversion
68: Normalization issue
69: join hint for openrowset
70: Replies by Celko
71: syscomments help
72: Create XML file from query
73: count and NULL values
74: I need unique customer records
75: Join with Like
76: Updating record in table with record from same table
77: Killing process
78: Updating record in table with record from same table
79: Error: Must declare the scaler variable for TVP in select statements
80: Execute a SSIS Package with VBA
81: UPDATE .Write equivilent for SELECT?
82: Select gaps from date range
83: Query Analyser from SQL Server 2000 vs SQL Server 2005 - look and feel of plans is horrible.
84: Options For Moving Data Amongst Databases
85: Column is Identity?
86: SQL 2005: PIVOT on character data?
87: Data type for html
88: SSIS "populate from source"
89: Query Active Directory for user's files
90: DataSet Max Length Compared to Oracle Varchar2
91: Select Language
92: stored procedure query
93: Which is better... Filtering on PK in FKey table or FKey in parent table
94: order by but with a flick
95: Catch error in trigger
96: SSIS: Using Data Flow to load data to Oracle
97: Disabled triggers
98: Finger print image
99: Query execution difference
100: How to get all attributes in one element
101: compare and delete in SQL2K5
102: character entities in my FOR XML statement
103: Query Help
104: Query SQL Server via SQL for version?
105: Serializable isolation level make deadlock
106: Hii
107: Encryption of financial information
108: I want to repair SQL Sever 2008 Express- Help!
109: Installation of sql server 2008 dev edition on vista
110: Indexing / Partitioning
111: Empty parameter in a SQL stored procedure
112: How can I use a SUBSTRING as part of the criteria?
113: Please help me with rewriting the query for performance
114: T-SQL Comparing a String of Items to a Table of Items; Listing Missing Table Items
115: 2000 Local Partioned Views vs 2005 Partitioning
116: selecting tables with primary key constraints
117: reordering a list of numbers
118: Cannot perform an aggregate function on an expression containing an aggregate or a subquery.
119: Query on several bases
120: Compute and Aggregate
121: IS NULL vs. = NULL
122: Help working on Large Database
123: Update Query Help
124: Substring Question
125: Creating a Linked Server Via Script (Procedure)
126: Statistics on locking during view execution?
127: SQL Performance help
128: data sampling
129: Update statement algorithm
130: kill all processes
131: Stored Procedures under TFS source control: SSMS 2005 and/or VS 2005?
132: Store Procedures and Jobs
133: SSIS: Retrieving data from Oracle to parameter
134: Help with view
135: Expanding hierarchy
136: Extended Stored Procedures C++
137: I cannot update and remove data
138: I cannot update data through dataset
139: Stored Procedures Operating On Tables In Other Database
140: Use variable in child stored procedure?
141: include Readtext result in a query ?
142: Need to copy data from table to another
143: getting multiple results from sql query for same event
144: list all foriegn keys
145: xp_cmdshell with network paths - Logon failure: unknown user name or
146: List the path for all MDF and LDF files of all databases
147: Group By week question
148: Stored Procedure Question
149: I have dysfunction in SQL Server 2008 Express
150: SSIS: Bulk insert with EncryptByKey?
151: First item in DTS package will not execute
152: SQL Server 2000: strange string behaviour
153: Backup/Restore database in SQL Express
154: Turning data into column headings
155: Report Subscription
156: Report Subscription Backup
157: using Database mirroring
158: Problem inserting new records into SQL Server 2005 table
159: need for for searching
160: fulltext search on all fields at the same time?
161: Assign permissions to table valued parameters
162: Select Dates
163: DropColumn sproc doesn't work anymore on SQL 2005
164: Using Like T-SQL Question
165: TRANSACTION ISOLATION LEVEL in a VIEW
166: Excel and SQL
167: like does not work on SQL2000
168: Left Join Maths Awry.
169: Enable Data Access for local server
170: v2005 make insert exec capture two result sets ?
171: why doesn't this Stored Procedure recognize the date range???
172: Problem getting sitinct value
173: Help with CTE
174: Help with CTE
175: odd "alter table" syntax
176: No not return anything in output if null
177: How To Use MERGE On Variables?
178: Convert Float to Varchar 2 decimals
179: Problem running stored procedure
180: INSERT INTO #TEMP with unknown number of columns
181: Use Windows 2003 or Windows 2008?
182: Convert data from float to string error
183: How to handle various options in single query?
184: trouble changing authentiation mode
185: DTS runs in Mode Design but no in IIS
186: Unable to make changes in design
187: Putting NET Framework Assemblies in a Separate Database
188: Making a list of items User-Ordered?
189: billiger strom und gas,stromanbieter wechseln nachtstrom,strom und
190: Data to large for variables
191: Transaction Log file for records with 3-day life-span
192: Is sql server installed
193: Flip table
194: Chinese antique
195: Question on strange behavior of SELECT DISTINCT statement.
196: Different data types causing problem?
197: SSIS Deadlocking issue
198: How to hanlde condition within inner join
199: Date SQL Help
200: Complex UPDATE using SUBSTRING
201: XML query result
202: Calling SSIS package from ASp.Net web page
203: Case Statement and Parameters
204: Database Mail Step by Step help
205: Case Statement With Parameters
206: SQL Server Enterprise Manager Shortcuts
207: Error connecting Teradata from BIDS - via ODBC - on 64 bits W2k3
208: Problems importing an Excel file to sql server
209: QUERY FOR MISSING SEQ DATE
210: Log trigger forces strange Access behaviour
211: SQL Server 2005 - Linked Server - order remote data - timeout errors
212: Capitalize only first letter of FirstName and First letter of Las
213: Calculate and sum the time different between two dates
214: How Configure SS2k8 DB To Prohibit Empty Strings In Columns?
215: Logical names of the databases
216: row versioning
217: Excecuting a dtsx file fails
218: DATE comparing
219: Strange code appearing at the top of ssms query windows?
220: granting execute permission on a stored procedure
221: understanding clustered indexes
222: CASE help
223: short circuit 2nd query
224: Column in index & unique key?
225: Grouping by fields X, Y and display top 1 of field Z?
226: save my diagrams
227: ADD COLUMN where the columnname is a variable.
228: How do I copy a table with data from database to another
229: The select list for the INSERT statement contains fewer items than
230: generating script on sql server 2008
231: table variables question
232: Execute Stored Procedure for multiple records
233: Update columns in main table from temp table
234: Create a view or just use the table itself?
235: Determine if an insert/update/delete failed in an after trigger
236: Datetime comparison for last 2 hours
237: Indian sucks`
238: Display data in a user form
239: return all values
240: Are Express mdf files different?
241: DB always in Recovery
242: Is there a way to find certain SPs calls a certain Dbs.
243: Long Checkpoints
244: Odd results
245: Setting UDT property with a select?
246: Where [DateCreateMonthNo] <> [DateInvoiceMonthNo]
247: Domain\MachineName$ Windows Authentication
248: Retrieve data from IMAGE data type in SQL 2005
249: Trying to write a GetDate function
250: Physical versus Logical Views
251: How tell Team Database project I have new database instance to point to?
252: IMplement SQL Agent scheduling on ASp.NEt web page
253: Substring Error
254: Forcing output to print during a long running stored proc.
255: user without login vs application role
256: Table join question
257: TOP 1 for each group
258: How bad are Client Transactions ?
259: How to delete null values in a row?
260: Display rows in a single line
261: Return Value from OpenQuery
262: Stored procedure output parameter returns null
263: Document Management in SQL Server
264: order of evaluation in where clause
265: database does not appear in ODBC Administrator
266: create view
267: create tagcloud
268: Problem in updating current datetime in a datetime field
269: sys.dm_db_index_physical_stats DMV
270: Two Instance Performance Issues
271: Joining 4 Columns from 4 Tables
272: Table exists question
273: tsql help
274: can i delay trigger until all statements have been executed?
275: SQLBulkCopy memory issue question
276: Question about Nulls and programming style
277: Can't create scaler function?
278: Who Created a Table
279: permission issue with sysperfinfo table...
280: TSQL Scheduled Job
281: Need to monitor log backups
282: foreign key references
283: Application logs handled by the database or the application itself?
284: Detecting insert, update and delete in an after trigger
285: SQL Server 2008 Express - Can't create FK?
286: Syntax question
287: Programmatically set OLEDB properties in SQL 2000?
288: Automatically start SQL server agent after reboot
289: Cannot run installer - Restart required
290: Exploring Transaction Logs?
291: Flatten
292: SP with insert exec called from another SP give me error
293: insert-exec
294: SQL 2000 Problem with Parameter in Function
295: cascading deletes
296: Trigger to update multiple tables
297: Aggegrate based on shortest string .. function required?
298: Question about a Pivot Query
299: help bcp command line with pipe delimiter
300: Use BCP IN where infile is an XML file and not an flatfile.
301: schemas and who should own them?
302: Sql Server 2005 Express and remote connection!
303: Indexes not being used?
304: RESTORE progress indicator
305: DDL_DATABASE_LEVEL_EVENTS
306: Performance comparison between SQLCLR and Transact SQL Trigger
307: informational raiserror messages
308: Linked Server for text files
309: using Char(13) + Char(10)
310: SQL Statement help
311: Legal / Electronic Discovery Question
312: Complex Insert
313: Also stuck on the same query
314: T-SQL Help
315: Where to get the Developer Edition?
316: recover msdb
317: backup and restore scripts for tables
318: 1 entry in SELECT clause reduces results to 1 row (??)
319: otra solucion
320: Same UDT on two database
321: How to limit data
322: Updating String with Decimal formats
323: Very strange performance issue. Why?
324: Check if a column is NULL
325: Is there a way?
326: Transaction Declarations/Rollbacks/Commits
327: t-sql to copy table to text file
328: LINQ + .Contains(s) + sp_executesql = big performance problem
329: create user failed / hidden user / strange things happens
330: ORDER BY problem
331: Reg XML issue i have attached sample coding
332: Help understanding Views
333: Trigger on update with a set of columns as primary key
334: tricky SQL question
335: sp still compiles w/ missing table
336: Help a noob learn?
337: Update with Date format
338: Stored Procedure Execution
339: Transaction to roll back inserts on error
340: Auditing Primary key violation
341: Trouble with error handling and transactions in nested stored procedures
342: list of columns of fulltext index
343: inserting batches of 10,000
344: Accessing UDT fonctionnalities in Transact SQL
345: help me
346: gettin sql server transaction id in different environment
347: between 2005 and 2006
348: FOR XML PATH ERROR
349: How to determine Isolation Level
350: Add column in SProc SELECT