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

view full version: back to formated view

15051: How do I know if I have SP2 for SQL Server 2005 installed?
15052: how to list a specific row in a dataset as the first row?
15053: Update ordering...
15054: Partial string link
15055: Query question (did not post first time)
15056: Sql Server 2005 Paging, Dynamic Order By
15057: Query question
15058: Dynamic SQL low performance in SQL Server 2005
15059: How do I do this SQL query?
15060: Arabi Sex Bitch
15061: How to fix this query?
15062: need to get max date and min date.
15063: table redesign... Am I on track??
15064: Creating a Summary Table - Pivot ?
15065: SProc Dependencies
15066: PIVOT in SQL 2005 problem
15067: Identity - table variables
15068: SP_OAMETHOD: getting back data into a tablevar?
15069: Informix and openrowset
15070: Server 'sqlken' is not configured for RPC
15071: Security
15072: Scalar function question
15073: Updating tabel with select.
15074: update on bulk of records...
15075: Management studio - Source control questions
15076: Sql view pb
15077: Return only highest Count
15078: Tutorial Website for Smart SQL
15079: Query an ODBC from Inside a Stored Procedure
15080: C++ and SQL image storage
15081: OpenSchema to get Unique Constraints
15082: Script to kill all user connections to a db except three
15083: Update fields
15084: String compare; common part
15085: Sql memory increasing
15086: it may be simple to convert..
15087: SQL Correlated Subquery Question
15088: dbcc pintable
15089: SmallDateTime
15090: User Info & Authentication
15091: Name Resolution
15092: convention for naming FKs
15093: Between Date and Time as 2 seperate fields
15094: Transact-SQL: additional column with aggregate funciton MIN
15095: How to make a 'deep' copy of a record with 'child' records?
15096: bcp help
15097: GUID column
15098: Escalating Lock Hell!
15099: UDF to return a "cleaned" column
15100: moving data between databases
15101: SQL query help?
15102: SQL2K Error Log
15103: Index and string concatenation
15104: How do I check for a Foreign Key Relation???
15105: DISTINCT record set adding a NON-DISTINCT field
15106: DISTINCT records adding a NON-DISTINCT column
15107: DBCC SHRINKFILE
15108: SQL Server 2000 PK Query
15109: Programmically open stored procedure in Management Studio 2005
15110: SQL Server 2000 PK performance question
15111: making international phonecalls
15112: SSIS an Load problem running under sceduled tasks.
15113: SQL Server 2000 Views and Views containing Views
15114: Why would this sproc run so slow when using default values for input parameters?
15115: Scan through NDF files
15116: Normalization Level
15117: Delete double entries - SQL Prog
15118: return control to user while executing stored procedure in backgro
15119: Column name with variable value
15120: How do I use OVERLAPS?
15121: SQL Server 2005 different versions
15122: Triggers
15123: using the value returned?
15124: visual source safe not in sync with Visual Studio
15125: Using Flash Drives
15126: named pipes
15127: Log Files
15128: detach/attach + index defragmentation
15129: get value of field?
15130: SCOPE_IDENTITY() returns weird value
15131: simple query question
15132: sp_runwebtask
15133: regarding reset identity column
15134: Regarding reset identity column
15135: Stored Procedure slow
15136: Moving row to another table
15137: Alter within If Exists
15138: Check when a stored procedure was last used
15139: CLR Stored Procedure Question
15140: SQL 2005: How to Change the SourceBlockSize from 512 Bytes to 4096 Bytes?
15141: schema
15142: Question on LEFTOUTER JOIN
15143: Possible to use variable to query linked server?
15144: SQL Profiler v.s. Execution Plan
15145: Table Partitioning
15146: SQL Mail Help
15147: Group By Query
15148: Who are Darwin's Outcasts?
15149: How do I connect to a SQL 2K table in VS05 with Crystal rpts VS E
15150: set certain fields to caps
15151: Resumes CV's / Positive vs. Negative Thinking Free Informational Site
15152: Problems accessing sql 2K via embedded CR in VS2005
15153: Linked server error 7399
15154: Import named range or specific cells from Excel into SQL Server
15155: Eliminating CRUD procedures
15156: The SP is processing very slow .
15157: Best resources on Query Notification in 2005
15158: Trigger on condition (data)
15159: USE <Database> is case sensitive?
15160: About rownum in sql server
15161: Select Query to ouput to a new table
15162: Strange error
15163: Keep SELECT lock during transaction
15164: Problem connecting to local SQL Server 2005 Express using "Microsoft OLE DB Provider for SQL Server"
15165: TOP (n) PERCENT Problem
15166: Querying a Subscription [SQL 2005]
15167: select for update
15168: Unable to use GetChunk() to read TEXT column
15169: Table Layout Suggestions
15170: parameters...
15171: Compare a query with a table row
15172: Select "top" partitions SQL2005
15173: Grab text of update query in trigger
15174: READPAST lock
15175: SQL compile error not trapped
15176: get quarter and week from date
15177: Suggestions for Data Model
15178: Stored Proc Help.
15179: @@ServerName
15180: Slow Insert performance on SQL Server!?
15181: Execute SQL Task - Problem Using an Input Variable
15182: Need a suggestion
15183: Need help with syntax
15184: Insert Advice
15185: SOMEBODY TALK TO ME
15186: distinct / group by / having
15187: online restore in 2005
15188: xp_cmdshell: what constitutes an error?
15189: Delete character bottom string
15190: To store result of stored procedure in a local variable
15191: Split Proc
15192: Management Studio Version 9.00.3042.00, Stop respond to Enter?
15193: retrive user defined tables from a database
15194: Statistics - Catalog Information on SQL2000
15195: Keeping Local recordsets - is it an effective way to program?
15196: constraints and udfs
15197: UPDATE query: possible to do search/replace on existing string?
15198: Groupby question
15199: moving backup from tape to disk
15200: Encrypted SP's
15201: Trying to implement a function ...
15202: Working fine locally but not link server
15203: db mirroring
15204: Return messages a problem in apps? (Column rename)
15205: SQL Query Compare
15206: xp_sendmail and operators
15207: Default permission and encryption question
15208: sys.dm_exec_query_stats and Logical Reads
15209: Need help optimizing a batch query
15210: xp_getfiledetails
15211: Table joins??
15212: Group count and Total count in one SELECT
15213: How to group by a boolean expression
15214: Help with Order By clause.
15215: Query to give me list of dbs + db size
15216: How to set string default value for column of type nchar
15217: split sp
15218: Number of Databases
15219: Check primary key then insert
15220: Is this a kludge?
15221: Query Help
15222: Restore and backup script questions
15223: Is there an inverse of DatePart function available in t-sql - DateTime(month, day, year) ?
15224: Novice? - Split and Allocations records in T-sql
15225: syntax help please for case function
15226: Trying to write a procedure in SQL Server 2000 to write to/update a table
15227: COMMIT TRANS causing timeouts within other procedures
15228: Joining tables between databases
15229: how to select the required result
15230: using the log file to find problem
15231: How to debug a stored Proedure?
15232: xp_startmail: failed with mail error 0x8004010e
15233: Barcode in Reporting Services
15234: Error 511 while not exceeding 8060 characters
15235: Date convertion problem
15236: DISABLE TRIGGER security issue
15237: Compress Result from sql query
15238: Compress Result from sql query
15239: 2000 to 2005 query processing differences?
15240: MSSQL equivalent / explanation of Access TableName, TableName
15241: Eliminiating duplicate data
15242: RESTORE DATBASE And sp_databases
15243: how does ado.net SqlDataReader.GetString() know which encoding to read the
15244: NEED HELP!!
15245: Group By Having
15246: Cannot create a row of size 8160 which is greater than the allowable maximum of 8060???
15247: Problem with a join
15248: Helo with SQL
15249: Grouped String Concatenation
15250: problem with additional formated information
15251: UPDATE Query ~ Help Please?
15252: If criteria is Null then show all.
15253: Searching across multiple tables
15254: Need advice on how to reprogram this SP
15255: exec('create table
15256: User define function couldn't return the table which has primary k
15257: FYI
15258: RAM Test
15259: combine output from SP's into one result
15260: Strange Connectivity Error
15261: consolidate two unrelated rows (update current row with cursor)
15262: Named Pipes Provider, error: 40 - Could not open a connection to S
15263: Rebuilding Table Indexs
15264: Lost Asynchronous Updates
15265: Select DISTINCT columns along with a NON-DISTINCT column
15266: sp_spaceused concern
15267: Philippine Sex Scandal
15268: Insert data from Excel to SQL server
15269: Strange locking behaviour with ADO
15270: PDF's again
15271: Increase size of msdb system database
15272: Differential backup problem
15273: SQL Server 2005 SP2 problem
15274: Convert date SQL
15275: transaction log size
15276: Linked Server to Oracle and Number problem.
15277: Split and Then Again Comma Separate Query??
15278: backup from standby server.
15279: Encrypt or decrypt our password
15280: varchar(max)
15281: Help needed combining two date specific event tables - Losing my hair trying to figure this!
15282: Data Architect VS Data Modeler
15283: Adding Column in middle of a table
15284: what's wrong with my stored procedure
15285: Using a SQL table as a work list for distributed clients
15286: Tracking system - referential integrity & normalisation with historical data?
15287: Debug Auto rollback in 2000 not Availiable 2005??????
15288: Constrains in SQL Server 2005
15289: dates
15290: Consistency of row when reading with READ UNCOMMITTED
15291: Cross-database user defined function
15292: summing rows of a field in a SQL Server 2005 view
15293: How to force table lock error?
15294: Please help with domain data
15295: Error handling in SQL 2005 .. is this right?
15296: DTS NOT RUN
15297: sp_rename error on SQL Server 2005
15298: Mirroring server restore
15299: Pseudo Pivot Table with a twist
15300: Parse in SQL Server 2005 CREATE VIEW
15301: cleaning out non numbers from a field
15302: data connection type?
15303: date compare
15304: DateAdd and DST
15305: Find file creation date
15306: Performance issue - Disk Queue
15307: Try and Catch
15308: Maint plan delete not working
15309: Disk Defragment on SQL Drives
15310: How to change the format of my data?
15311: Change Management - Straw Poll
15312: MSReplCommands and MSRepplTransactions table in SQL 2005
15313: DBREINDEX on SQL 2005
15314: Index and Data Placement
15315: Raid 1+0 or 0+1?
15316: ORDER BY problem
15317: Query - Help
15318: XML Load in SQL SERVER 2005
15319: Backup SPL for review
15320: nested SELECT CASE (if, then)
15321: sysobjects name field padded w/ _'s
15322: smalldatetime format problem
15323: Grouping
15324: Integrated security
15325: =?Utf-8?Q?How_to_handle_different_database?=
15326: How to handle more than one SQL Queries in Crystal Report? - in AS
15327: urgent
15328: Counting total workdays
15329: indexing columns used in where clauses
15330: Update or select query without cursor
15331: Trouble Calculating a "score" when the Value is Negative
15332: MS Access / SQL Query
15333: Case statement in sql server 2000
15334: insert into linked server problem
15335: Copy Database Wizard : Where is it?
15336: Use of trigger to enforce uniqueness
15337: LEFT JOIN
15338: flag a record as "exported"
15339: How to transfer comments to SQL Server2005 from SQL Server 2000
15340: OpenXML: XML parsing error: Reference to undeclared namespace prefix: 'n1'
15341: real to datetime - how to...?
15342: Linked server only shows local database table results
15343: Recursive "Instead of" Trigger
15344: Find a computer that is inserting records into my database
15345: Table design Question. Type field?
15346: Another PDF question
15347: SSIS - 1st row nulls on import
15348: PDF into a sql table
15349: SQL Server 2000 PRINT
15350: How best we can rewrite this SP without using Dynamic sql ...
15351: region
15352: Deletion using multiple records without using cursor
15353: Deallocate statement hangs
15354: Commented out SQL Block
15355: Deadlock issues
15356: XML (How can I pass parameter to Xquery?) please help...
15357: Insert into mySQL via SQL Server OpenQuery
15358: Time change and service packs
15359: run a console application from inside a trigger?
15360: Assignment in text data type in sql server 2000
15361: NOT IN with a subquery
15362: PLS Help-Synchronizing using SQL server 2005
15363: Data Fetching Problem
15364: Data Fetching Problem
15365: Smart join when working with UNION
15366: Performance problem
15367: Something Like subclass in SQL Server
15368: database roles & installation of a database
15369: Updating a table
15370: Update through dts import/export
15371: Error reading varbinary data
15372: Insert update / select from other table
15373: performance problem
15374: Common issue - query response time
15375: Mathematical operations between two sets
15376: A couple of time-tracking questions
15377: Subqueries
15378: Hierarchy loop lookup syntax
15379: SqlParameter() length of VarChar field? Important? Optional?
15380: SQL Server 2000 Linked Server Problems after Server was attacked
15381: Row Level Security
15382: column alias in where (looking for alternative)
15383: Select query question
15384: Transaction Log Size
15385: Making Word object visible from T-SQL
15386: need help in sql query
15387: SQL 2005 not using index on large tables?
15388: how to select records 1-25 or 26-50, etc
15389: Procedures working from Management Studio but not from Access 2003
15390: Data manipulation question?
15391: Twelve Proofs that Muhammad is a True Prophet
15392: Arrays and lists in SQL 2005
15393: for a better understanding - the table structure as script
15394: Column does not allow nulls when saving
15395: calcualte "special average" depending on colums values
15396: left join/inner join/outer join with repeat values
15397: Cheap way to get a count on a large table
15398: no duplications in inner join / left join / right join query / JOIN HELP
15399: How to check the records have been locked when you select the reco
15400: Server roles in MSSQL 2005