TheMSsForum.com >> SQL Server Programming >> Archive Page 85 - The Microsoft Software Forum

view full version: back to formated view

29401: Program Logic
29402: Problems Enumerating Role Permissions with SMO
29403: Varbinary columns...
29404: Is it possible to use a Function directly as a Input Parameter for a Inline UDF
29405: Job LastRunOutCome??
29406: Joining Tables
29407: SQL Server Express 2005 and VS.Net 2003
29408: Biztalk 2004 & SQL
29409: inserting single precision data into sql server float column
29410: Funny! More offers to select a search engine! (PP)
29411: SQL Help - dynamically change where condition
29412: DateTime Bugs??
29413: SQL dilema
29414: Funny! More offers to select a search engine!
29415: on insert trigger and a linked server?
29416: GetDate inside a Function
29417: performance on the join
29418: Cant It be Done?? Backup mdf and ldf only
29419: User Instances and Scripts
29420: CTE vs. Table Variable (Paging)
29421: generate three rows out of one row from a table
29422: can't insert into ...because of nulls problme!
29423: Consoldate columns in a SELECT
29424: Programatic replication
29425: Backup Contains .mdf .ldf and .ndf dont want .ndf
29426: Encrypting Stored Procedure Code
29427: how to read a 1204 and 1206 trace log entry
29428: Stored procedure problem - update help needed
29429: SMO-license
29430: How to get the name of the column that is an Identity Column
29431: Job issue
29432: Query Timeouts--Indexing Questions
29433: Advice required on database structure
29434: sql division
29435: Network Packet Size
29436: statistics io question
29437: VS.NET 2003 and Stored Procedure Debug
29438: Object search feature
29439: big log file
29440: 3 tables ...
29441: Returning Duplicate Records
29442: Parse w3c Date and Time in SQL Server 2000(sp4)
29443: Indexed Views, Space Used.
29444: Stored procedure; add row to ouput result set
29445: Return random number from trigger
29446: nolock
29447: Problem of Permissions for Linked Servers in .net page
29448: Which sp is causing the blockings...?
29449: Queries for Back up and restore the databases
29450: SQL Statements or Table Redesign
29451: SQL 2005
29452: Another Temporary Table Q
29453: Help on "splitting up" data in a field
29454: SQL Server Browser service?
29455: Temporary Tables
29456: Stored procedure in asp timeout
29457: Usage of RaiseError
29458: Job/DTS Scheduled Execution
29459: Scheduling DtsBackup2000?
29460: TDS buffer length too large
29461: Help on passing param to store procedure ???
29462: Can You SQL Inject this code?
29463: Unicode encoding problem ?
29464: SQL-DMO scripts or something like that
29465: Help obtain a window of rows from a table
29466: local ip address
29467: Using output parameters in SQL Functions
29468: !!Famous Software ftp download 2006!!
29469: Another Slow Execution Plan with sp_prepare
29470: Is there a better way to write this?
29471: Exporting data using ONLY the WebAdmin interface...
29472: Automation scripts??????????????
29473: SQLExpress - User Instance OSQL
29474: replace spaces in a quotation
29475: Query to do chart
29476: profiler
29477: nvarchar(max) question
29478: Wrong Execution Plan
29479: info..._schema.routines no Triggers listed - how to find scripts?
29480: Filegroup Question
29481: Help with an SQL query
29482: Upgrade Script
29483: SSIS and SQL Proc
29484: Retrieve the error description
29485: Retrieving error messages
29486: Retrieving the error message
29487: Extending SQL Server Management Studio
29488: Query Analyzer Anomoly or not?
29489: Slow Query with sp_prepare and sp_execute
29490: Conditional inserts in trigger
29491: Replace data portion of a column
29492: custom datatype SQL server 2000
29493: Determine the type of trigger
29494: Inside Common Table Expressions (CTE)
29495: ActiveX Scritping was not able to initialize the script execution
29496: Bulk Insert Import Question
29497: multiple large table scans
29498: Creating SQL Triggers
29499: Stored procedure problem
29500: Indexed Views & Constraints
29501: very slow queries after restore database
29502: Can .BCP file open in text editor?
29503: Select Max(somecolumn) + 1 problem??
29504: Returning A Scalar Value
29505: Copying Records into a different table using triggers
29506: create rule
29507: How to prevent from deleting record?
29508: Update problem.
29509: sql syntax calculated field in view
29510: exec stored proc and use udf or select in it
29511: DB Redesign - use junction/xref table?
29512: Possible self-join question
29513: SQL Jobs/Tasks priorities
29514: Urgent help needed!
29515: Selected Data Deletion
29516: Problem with comparing a Table View Column with the Table Column?
29517: SQL 2005 Mirroring Databases
29518: PRB: INSTEAD OF UPDATE trigger fails when UPDATE is done from an stored procedure
29519: Connect SQL Server 2005 through SQL-DMO
29520: Search through dts
29521: Convert to Julian Date
29522: Error during Removing the DB access to BUILTIN\Administrators
29523: Hooking up multiple databases in order to be able to key into the data more easily
29524: Is there any advantages of using views in the same DB instead of tables in a different DB?
29525: Transaction question
29526: Remote SP debugging from VS 2003: error
29527: Are there any issues with installing SQL 05 on dual boot system - D drive?
29528: SQL Parser
29529: select & update data with special characters
29530: About CASE and WHERE
29531: Instead Of Trigger Question
29532: LIKE % % statement
29533: INSERT Help Required
29534: trigger and stored procedure
29535: Reporting Services Error
29536: Some assistance with MS SQL injection and PHP please
29537: master db id
29538: DTS & Trigger
29539: OT: Need Some Help
29540: Need paragraph breaks in pass through query
29541: HOWTO: Select multiple categories joined with a record?
29542: Determining User Role via DMO
29543: Embed VBS or Call VBS from Job Script
29544: need help with sql query
29545: Creating a view between 2 different Datasources
29546: Primary key violation on update
29547: divide by zero error
29548: Problem causing batch file with xp_cmdshell
29549: Rolling Month Query
29550: problem with output SP that takes Input
29551: Calendar table SELECT
29552: convert into to hours minutes
29553: CREATE TABLE with multiple-column primary key?
29554: DateTime types and getdate() comparison
29555: Debugging SPs in SQL Server 2005
29556: ODBC In Stored Procedure
29557: ALTER TABLE Question
29558: A question on database design
29559: Syntax error near MOVE
29560: Re: How can I find a comma in a field
29561: How can I find a comma in a field
29562: Contains(@v1, @v2) Is this legal?
29563: Why do these queries return a diff. # of records?
29564: CTE to replace cursor
29565: System.Data.NoNullAllowedException: Column 'frDateCreated' does not allow nulls
29566: Trying to get xml data with unknown level of nesting
29567: passing or defaulting null
29568: Qyery returns different results on SQL server 7.0 and 2000.
29569: Previous and next ID
29570: Selecting Max Value
29571: Data Modeling question
29572: Sub select with retrieval argument doesn't work
29573: Get the ID from Min(grouppingcolumn)
29574: Help with query
29575: copying data accross databases for backup
29576: query in query?
29577: database migration
29578: Overlapping Records by DateTime
29579: set ANSI_NULLS ON
29580: RDA with limited connectivity
29581: dynamically changing or concatenating the where statment in a proc
29582: How to start SQL Server programming?
29583: Role Permissions
29584: Limit of SQL2k table....
29585: Passing A Field Name as a Parameter (Dynamic SQL?)
29586: left anti semi join - puzzling problem
29587: Type Casting Problem
29588: Stored Procedure with Parameters and "in" clause
29589: find a string within a string regardless of position within that string
29590: Is there information_schema.view for count of rows in tables?
29591: quick query question
29592: Create database using dmo and sql2005
29593: Unable to Update Table Even After Dropping Constraint
29594: SQL 2005 Unique identifier problem
29595: How to assign value to a TEXT variable and return it
29596: Running Stored Proc inside of Access and getting error
29597: Refer to a field in a header
29598: How to assign value to a TEXT variable and return it
29599: QA Setup question
29600: Cross table copy working in Query Analyser, but not from code
29601: Is there an easy way to check MSDE DB size from VS 2003?
29602: Call udf returning a table variable from a stored proc.
29603: massive SELECT's causing lots of deadlocks
29604: How to return Integer as a string in stored procedure?
29605: SQL Help Wanted - Useful Websites
29606: Removing records
29607: Do I use case or coalesce or something else?
29608: complex set base queries and performance...
29609: complex queries and performance
29610: Are these equivalent?
29611: report when was last used the stored procedure/view- in a DB
29612: Generate reports programmatically with reporting services & SQL server 2005
29613: How do I return a recordset or table from a stored procedure?
29614: SELECT and UPDATE simultaneously
29615: A very simple select query question :-)
29616: Count days between to dates group by month
29617: integer indices in 'over' clause of row_number() function in SQL20
29618: Restoring data from SQL-2000 to SQL-7
29619: BASECOLUMNNAME property in recordset not updating from stored procedure
29620: Can I use table data type in a trigger?
29621: Query Aggregation
29622: Restoring data from SQL-2000 to SQL-7
29623: Help on storing big text ??
29624: Someone MUST be able to solve this ??
29625: Add Foreign Key Constraint in filegroup
29626: Looking for a system procedure
29627: Searching for referenced columns in a Stored Proc
29628: Stored Procedure Behaves Unpredictably
29629: How to detect if a schema if exists or not so that I will not create same schema again?
29630: SP_ExecuteSQL
29631: Possible SQL Bug with clustered indexes and DOP > 1
29632: Merge Agent takes all the CPU time
29633: Dynamic SQL weird stuff
29634: Prompt Parameter Query?
29635: Size of objects
29636: SQL 2005 & export stored
29637: Date Fields
29638: scope_identity Vs Parameters
29639: bulk import... SSIS VS custom job
29640: Memory Usage
29641: SCOPE_IDENTITY() / ADO.NET FAILS
29642: query no longer working??
29643: Performance problem
29644: Server Size on Ram
29645: String Manipulation
29646: Getting all users that using sql
29647: SMO Create Database SQLExpress Access Denied
29648: SImple DTS stuff
29649: Logical Design!!!
29650: Need help with trigger -novice-
29651: repost on subtracting date range data between tables
29652: problem with filtering data
29653: trying to implement simple while loop
29654: saving value of COUNT function result
29655: Update and Delete command
29656: newbie openquery question
29657: Outer Join and WHERE clause strange behavior
29658: MINUS operation between table date ranges, is my algorithm sound?
29659: Possible to get column number on a bcp_sendrow failure?
29660: Moving a database
29661: Verify existing Child Data
29662: SQL for custom paging solution
29663: Dynamic SQL and @@Rowcount
29664: Signalling between two applications
29665: Selecting Duplicates - all data
29666: Most recent data point?
29667: Replce SPACES in values
29668: "did you mean" feature
29669: "No more data available to read" error
29670: Help! Query Question.
29671: DB Change Deltas HELP!!!
29672: Performance of UPDATE commands on individual records
29673: Standard Deviation
29674: generic audit trail best practice questions
29675: sp_OAGetProperty procedure is giving error
29676: append a string to all the values in a column SQL
29677: BCP IN: create table on-the-fly
29678: Alter a constraint?
29679: SQL Syntax Question
29680: Constraint
29681: Moving tempdb
29682: Date query
29683: Statistics Deadlocking
29684: Why SQL2k and SQL2005 Return Different Order for sysindexkeys?
29685: Obtaining different timings for the same process??
29686: Is OR so bad?
29687: MTS Query
29688: handle errors in trigger
29689: Obtaining total of partial
29690: What's a good SQL server naming convention
29691: Extracting from linked tables into pivot
29692: SQL profiler
29693: Insert into table with union?
29694: Max question
29695: set theory operations on two tables containing date range data
29696: complicated Join - duplicate row problem
29697: question on inserting a record on sql server with identity column as key
29698: Journal table for a database
29699: Update Query!!!!
29700: Inserting same identity value into two linked tables
29701: Indexing datetime field for selecting dates ranges
29702: User Function Date parameter
29703: Optimizing an IN clause
29704: Can not create trace file
29705: Advanced Sql-Shape Query - Help
29706: NULL issue
29707: SQL 2k5 vs 2k - different results on same execution? ORDER BY prob
29708: IF UPDATE ( column)
29709: one ado connection object - multiple spids?
29710: grouping a few columns
29711: Looking for Query
29712: Division question
29713: DeadLocking
29714: Searching a datetime field by time
29715: Add the end date to record
29716: Searching on partial match in a text field
29717: Subquery Problem
29718: Override Checking...?
29719: scientific notation and CAST or CONVERT
29720: 1. print current count 2. decrement date 3. subtract previous count from new count
29721: Retrieve list of tables without triggers
29722: Installing SQL 2005 Beta
29723: upgrading to 2000 from 7.0
29724: Connecting to SBS SQL via Remote VPN (VB Application)
29725: Pivot Table
29726: What is this called, and how to do it?
29727: ASC/DESC as SP Keywords?
29728: Create record each day from time frame
29729: BACKUP DATABASE
29730: assign truncate rights to a user
29731: Syntax please
29732: How do I use ADO in VC++ 7.0 to get the size of the database
29733: Query Problem
29734: bcp issue
29735: Drive capacity
29736: Sql Server 2005 possibilities
29737: Index
29738: CREATE TRIGGER on system tables
29739: Is there an easier way to programitcally create a new database and login user
29740: Stored Procedures Permissions
29741: convert hex string to hex literal
29742: Access 2003 and SQL Server Development - Best Practices
29743: SQL Server vs the Competition
29744: MS DTS Object Package Library
29745: Filter on view Problems
29746: select * from inserted
29747: Stored Procedure Error - Newbie
29748: create a temporary table
29749: MSAS Meta Data
29750: reverse order of hex bytes