View Full Version : sql server answers


Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 [19] 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37

  1. SQL Running process
  2. replication
  3. Whitepaper: "Yellowfin Reporting" enables Embedded Business Intelligence
  4. Max Row Date
  5. How do I get a count of each set of results?
  6. Changing DSN to DSN-Less
  7. Logging information about items of the Data Flow Task?
  8. adding unique keys
  9. SSIS Packages Dashboard
  10. Incorrect syntax near the keyword 'THEN'
  11. SQL 2000 dies on JOIN query
  12. 6.5 master database syslogs full
  13. data transfer
  14. columns as rows and rows as columns
  15. Viewing transactions in SQL server 2005 express
  16. what is informatio_schema.<something>
  17. sum problem please help
  18. USING 'CASE' TO GROUP DATA
  19. SQL query dilemma
  20. mp3 songs in SQLSERVER
  21. Trigger on a table in TempDB
  22. User authentication
  23. SQL DTS to DB2
  24. Collation problem - urgent help
  25. okay, I'm frustrated....how do I
  26. Problem with SELECT
  27. SQL Server 2005 - FILE manipulation hanging....
  28. Difference between 2 tables
  29. flat file connection string
  30. nee stored procedure please help
  31. Using SQL Server 7.0, Backup maintenance plan not working
  32. Summarize Unique changes of registration
  33. sqlserver 2005: indexes on raid-0?
  34. Creating rows based on date range from another table
  35. SQL Insert Help
  36. transaction log
  37. Move Databases on SQL 2000 Machines
  38. Changing stored procedure Freezes Crystal
  39. Recommendation for tools converting access databases to SQL
  40. Log Shipping Snyc Problem
  41. Using aba_lockinfo in a loop
  42. Help with query - anyone??
  43. Absolute Newbie Question
  44. Alter a SQL table
  45. do SS transaction logs have to be backed up for recovery to POF?
  46. Access to SQL Server Query Translation
  47. Best way to move datafile from C drive to D
  48. Hourly Average
  49. OLAP Specialist vs OLTP one?
  50. SQL Server 2005 Opening Script File Problem
  51. how to add primary key in existing table
  52. Does truncate and API Load invalidate statistics
  53. Slow Insert in SQL Server
  54. SQL select statement needed
  55. I can't create a temp table
  56. SQL access problem (SP2 pre-installed)
  57. Array / Table As return Type
  58. union all and order by problem
  59. Weird situation - Stored procedure executed twice
  60. installation problem for SQL 2000 Development Edition
  61. Trying to do REALLY simple procedure and loop in SQL Server
  62. SIMPLE command to convert string to number? Not CAST or CONVERT.
  63. SQL 2000 only using 8GB of 16 GB available
  64. Only update changed columns
  65. suggestions for books
  66. Views, UDFs
  67. Stored proc duplicating data
  68. Views
  69. After SP4, proc w. Cursor doesn't release keylocks
  70. Using FormsOf(INFLECTIONAL, )
  71. Multiple Search Criteria using FREETEXTTABLE function
  72. clustered vs. non clustered
  73. copy database via tapefile no SQL 2005
  74. need help with LEFT JOIN statemen
  75. Almost there with bulk insert
  76. Create View in SQL Server with data types
  77. SQL Server trigger that fires only on update of certain field?
  78. transaction logs full
  79. MS SQLServer or Pervasive SQL 2000i
  80. Validating State abbreviations using a Check Constraint
  81. Selecting on multiple tables
  82. SQL Server 2000 / [USA edition] = UK ???
  83. dependent assembly microsoft.vc80.mfcloc could not be found
  84. dependent assembly microsoft.vc80.mfcloc could not be found
  85. Accessing form controls values through ms sql fuction
  86. SQL 2005-Config Manager contains no data
  87. SQL Server 200 Developer vs Enterprise versions
  88. Weird DTS Problem
  89. Trigger problem in SQL
  90. Get the latest result (new in sql)
  91. Trouble with Impersonate User, ODBO and Analysis Services
  92. Hey I've got a homework problem I'm working on and am stumped.
  93. ALTER TABLE from sqlcmd script
  94. How to switch off automatic blanking of table views in enterprise manager ?
  95. 'MSDASQL' headache
  96. Flattening Parent Child Hierarchy: Urgent please help
  97. Error in Creating table in Sql server 2000
  98. New to stored procedure
  99. format files for use with bulk insert
  100. How to creat a sp for insert datas...
  101. Get files in different folder using sql
  102. Skip rows where the first column with letter 'S' - BCP
  103. Get column names with the corresponding table name from a SELECT with JOINs
  104. SQL Server Management Studio can't 'see' the 2005 engine?? But can see 2000 ?!?
  105. Tying together tables
  106. Database design question
  107. Change Logical Name in Script
  108. TRAN_ABORT gone?
  109. Global ODBC Settings
  110. Regional Setting in MS SQL
  111. SQL Challenge Urgent, Please help
  112. Cant install SQL Server '05 EE, VB 2005, or Visual Web Dev 2005
  113. Query Analyzer. What settings to see the data output again?
  114. Query Analyzer. What settings to see the data output again?
  115. Import multiple csv into multiple tables
  116. Is DEFAULT a constraint?
  117. Using Union and Join in a single view
  118. SQL Round
  119. How to get last date only once all have been filled in
  120. How to restrict evil create scripts?
  121. What is the correct sequence of Restoring databases in SQL Server 7.0
  122. SQL Server 2005 + SQL Server Express
  123. need some help
  124. Moving SQL installation to a new Partition
  125. On to Bulk Insert issues
  126. Need help adding 3rd table to a Join
  127. Error 22272: Cannot load the DLL xpstar.dll...
  128. understanding triggers
  129. Reporting No Records Found
  130. Script, Save, Export SQL 2005 Database Diagrams
  131. SQL-SERVER - APPEND from different databse's table
  132. Supress Column names in the output
  133. Table structure and data transfer from SQL2000 to Access (.mdb)
  134. Understanding constraints and binding
  135. How to implement a foreign key
  136. Move from SBS2003 MSDE to MS SQL 2005 Express
  137. How to recover deleted data from master database
  138. Update SQL from Excel - newbie question and a challange
  139. Tough query?
  140. MS-SQL Related
  141. Survey: Enterprise Architecture and Software Development
  142. SQL Server 2005 Express to SQL Server 2005 Standard
  143. trouble porting a trivially simple function - with declared variables
  144. 2005: cannot to connect from .NET
  145. Using SQL to append records to a table from a flat file using DTS
  146. Sql Server Hot backups (Clone/Fracture)
  147. Any help?
  148. Unable to Create a Maintenance Plan
  149. SQL Server 7.0 equiv of IDENTITY_CURRENT
  150. Help with Database Solution
  151. Help! Need to extract date/time from SQL database table
  152. OUTPUT and Recordset
  153. table owner
  154. Problem with cast error in adventureworks sample
  155. Count of records inside the records but based on distinct?
  156. loading data from text files
  157. SQL 6.5 upgrade to 2000
  158. Migrating data from DB2 to SQL Server
  159. What To Join?
  160. What To Join?
  161. Specify SQL2005 LogFiles Path on Install
  162. moved from ms sql 2000 to ms sql2005
  163. Insert Problem in MS SQL
  164. Starting
  165. Distributed Transaction Coordinator on SQL Server Cluster
  166. SQL Server 2005 and file systems, any recommendations
  167. passing tablename as parameter to function and to use it dynamically
  168. How to change owner for all tables in a database.
  169. ODBC readonly (viewonly) linked tables....
  170. More questions about porting from MySQL to MS SQL
  171. Reclaim disk space after DROP columns
  172. questions about keys - porting code from MySQL to MS-SQL
  173. SQL query
  174. Help! I'm using MS SQL Views
  175. Accessing SQL2005 as a Second Instance to SQL2000
  176. Compare Two Queries - Help
  177. Limitations in a query !!
  178. Problems when trying to build Connection to SQL Server Express from ASP.NET application
  179. Set time for UTC
  180. Previous day query
  181. Having Problem While Importing a Text File
  182. Select Statement Problem
  183. Why the memory usage of SqlServer doesn't go down
  184. Inserting a record using values from another Stored Procedure
  185. Recommendation os SQL Server Monitoring Tool
  186. Scrambled data in some fields
  187. Help with case when
  188. Allow NULL or Define DEFAULT Value
  189. i'm a newbe. please help
  190. Alter Table
  191. Reads and writes to a sql server database per table
  192. Very Small Numbers
  193. It proclaims of the Commandant in Boss Fidel Castro to the town of Cuba.
  194. Proclama del Comandante en Jefe Fidel Castro al pueblo de Cuba
  195. How to export xml in dts "Excute SQL Task" to a flat file
  196. Data Transfer
  197. Find which SPs have quoted_identifier set wrong
  198. Transposing rows to columns
  199. SQL Profiler hanging
  200. Problems when upgrading to sql server 2000 sp 4
  201. SQL 2005 Developer edition - install problems
  202. Satan and the evil
  203. Referencing colum names in recordset which is created by join - URGENT!
  204. FULLTEXT SEARCH any drawbacks??
  205. MS SQL & Visual Studio 2005
  206. Create Ranking Column
  207. Sorting with NULL
  208. Sorting with NULL
  209. Question about summing up different fields in different records
  210. 64-bit SQL 2000 Compatibility
  211. dts dynamic query & automap columns question
  212. AFTER INSERT trigger not firing in SQL 2005
  213. Index Computed Column?
  214. xp_cmdshell/DTEXEC in SSIS
  215. Delete Non System Table
  216. 2005: problem with Books Online
  217. optimising the following query
  218. Ordering results by order of the "IN' clause
  219. query optimisation
  220. Some issues regarding using MS SQL
  221. Yeartodate
  222. Working with NULLS
  223. Using xp_cmdshell to run application that uses domain credentials
  224. How to Access Query Anaylzer?
  225. [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
  226. select minimum between two values
  227. new to sql....can anybody help..
  228. Having problems calling a procedure which returns output variables from another proc.
  229. Calling all MSSQL 2005 Experts
  230. Use both DBs in cluster?
  231. BULK IMPORT Stress
  232. CPU spike with SQL Server 2005 Express Edition
  233. Query optimization via table properties?
  234. Searching a database
  235. Urgent -- Outer Join Problem
  236. Change monitor server settings for Transaction Log Shipping
  237. SqlServer View Tuning
  238. backup job hang
  239. Admin Version of WITH(UPDLOCK)?
  240. 2005: installing Business Intelligence
  241. create trigger or stored procedure in external DB?
  242. MS SQL 2005, .NET, logins/sec and page faults
  243. 2005: Service Broker?
  244. sp_who and Citrix
  245. delete particular rows in a table
  246. syntax error ALTER TABLE
  247. Deleting more duplicates
  248. Select query help+primary key
  249. DTS Import Update table.
  250. sp_change_secondary_role missing in SQL Server 2005?
  251. Linear Regression for column values
  252. 2005: BACKUP
  253. System event triggers
  254. Deleting a column DEFAULT....
  255. Problem with Insert Exec in nested SP
  256. Wanna create a table field name as 'Name'
  257. Help with an online game project
  258. Sql Inner Join..
  259. Encryption Password
  260. Text column data incomplete
  261. SQL 2005 - SQLDMO - Adding Logins/ Users
  262. Recreating/reloading system stored procedures
  263. SQL Statement - Join
  264. Replace Access with a .NET front end and SQL Backend solution.
  265. Question on QUOTED_IDENTIFIER
  266. The best way to display values from a CURSOR
  267. ms sql 2005
  268. Newcomer to the whole milieu
  269. ODBC Timeout - Where to start looking
  270. Cryptography API for MS SQL Server
  271. SQL7 Files and HardDrive issue. Please Help
  272. DTS export to Excel
  273. Urgent SQL7 ISSUE
  274. Reduce Table Size without deleting data
  275. SQL Generator
  276. Updating text containing , or
  277. Scripting table with rows values
  278. MS SQL Caching
  279. Exporting data from SQL 2005 to Access
  280. Text Import Finding Table to Import to Problem
  281. Subquery Help
  282. Delete 2005 [user] schema?
  283. How to send an automated email when SQL Server 2000 is shutdown...
  284. select no. of rows from the current database
  285. Formatting text file using DTS Select/Export
  286. Conversion datetime to string
  287. 2005 Express Edition: installing full-text search
  288. Trigger Between Linked Server - DTC Issue
  289. query to populate child table
  290. not permitted in this context
  291. SQL Server 2005 Script Generation
  292. quicker way to create indexes
  293. Terminal Service Manager
  294. URGENT - Link server 2005 to 2000
  295. (2000) Unable to connect to debugger
  296. Second Transaction Log File
  297. LongestRunningQueries.vbs - Using a VB Script to show long-running queries, complete with query plans
  298. 2005: creating aggregate function from .NET assembly
  299. Book recommendations?
  300. What do you mean 'clustered' index?
  301. Server Components Can't Be Installed
  302. SQl Server 2005
  303. SQL Server
  304. sqldata dictionary
  305. Red-Gate SQL Log Explorer
  306. Table design request for comment. (Help please)
  307. need help regarding finding rows modifeid during certain time frame
  308. Column permission being ignored by Access Form Combo box
  309. Micro-pump is cool idea for future computer chips
  310. Remving duplicate rows and NULLS
  311. Fill Factor
  312. Automatic Import of Emails
  313. Size of Row
  314. Multiple files import
  315. Check if a Table is used in any sp or function
  316. Input string -> table -> output string?
  317. Query to find a missing number
  318. SQL 2000 Error: 1203, Severity: 20, State: 1 Error
  319. SQL Server 2005 Startup error - TDSSNIClient... error 0x5... code 0x51
  320. De-normalizing query
  321. problems with query
  322. Limits in SQL 2000
  323. Character find and replace
  324. SQL Server 2005 JDBC 1.1 integrated security question
  325. SQL Server 2005 SP1 install
  326. changing records in tables
  327. Cursor loop
  328. vba sql server connection
  329. 955585 - Limited Term Employee / Infrastructure...position at hewlett Packard
  330. Backup and Restore on different computer?
  331. Using Decimal as a Key
  332. Problem with INSERT Trigger
  333. How to get modified time of a table
  334. Reporting Services 2000 & 2005 on same machine
  335. Reporting Services 2000 & 2005 on same machine
  336. Transact-SQL SUM Help!
  337. Get all table names with a given column name
  338. Problem with stored procedure and retrieving inserted identity value
  339. Error OLE DB
  340. Problem with installing SQL Server
  341. 2005: using SMO
  342. 2005: Business Intelligence Development Studio?
  343. How to combine 2 records into 1 unique record
  344. Strange results from "not in" query
  345. SQL2005 SSIS - won't allow text delimiters
  346. Turn of logging on SQL maintenance plans
  347. 2005: calling .NET procedure
  348. Databse Link will not connect
  349. I HATE Management Studio, how about you?
  350. Search Char in SQL query
  351. BCP using ODBC - problem with unique identifier
  352. Need help with denormalizing query
  353. Smarter Table build - might split the table
  354. Newby DTS Question
  355. MS SQL database Transfer
  356. 2005 EE: using full-text indexing
  357. stored procedure question
  358. sending a parameter from an access database to a DTS package in sqlserver
  359. Hierarchy
  360. Query: union on self
  361. User Defined Data Types Problem
  362. key column information is insufficient or incorrect
  363. Northwind database extra SQL needs
  364. Make and save a blob on the fly in stored proc
  365. Need More SQL Query NewID Help
  366. OUTER JOIN not working?
  367. Delete statement for a list of items with multiple columns identifying primary key
  368. Insert Function Help
  369. ADS user and sql 2005
  370. 2005 Express: testing replication
  371. Hide SQL Server DB; 2005 version on Win 98
  372. pulling all dates within a date range
  373. Insert Subqueries
  374. Odd SQL IN usage?
  375. Design question related to Grouping
  376. exporting to CSV
  377. Access Sql server using Javascript
  378. 2005: forbidding INSERTs and DELETEs
  379. Please Help with SQL Query Problem
  380. Building an application on multiple data sources
  381. BEGINNER: simple Delete trigger
  382. sequence of columns and preformance
  383. MS-SQL one .NDF file missing How to Recover/Rebuild DB??
  384. Create trigger - do users need to be out?
  385. Bizarre Query
  386. Problem when changing Views
  387. Update unique records only help
  388. Consolidate information from multiple rows into one row
  389. SQL 2005: keeping track of database changes
  390. Empty recordsets and artificial records
  391. How application can detect node restoring?
  392. need programmer to build a dts...
  393. to find a particular record set is present or not?
  394. Querying Windows Active Directory from Sql Server 2000
  395. Querying Windows Active Directory from Sql Server 2000
  396. comma separated values to stored procedures
  397. Announcing Yellowfin Version 2.5 release for SQL server based users
  398. SQL server 2000 timeout
  399. How to move transaction logs on-line?
  400. attach db MS SQL 2000 .BAK with enterprise manager
  401. multiple rows and columns MAX
  402. Getting Count(*) From Left side of Join using WHERE on right side of join
  403. How can I do a exact wording search?
  404. OR in the WHERE Clause?
  405. why don't group by work????
  406. memory usage/allocation/paging question
  407. Returning the newest rows
  408. conversion from Access query to mssql query
  409. SPROC won't execute - insufficient permissions
  410. Does anyone know of a tool that allows a SQL Server database to be
  411. inserting into two tables and transaction problem
  412. Sending email (recipients)
  413. SQL Server 2005 Express
  414. Export Image Data Types to Local PC from SQL Database
  415. Update statement, then insert what wasn't available to be updated.
  416. left() and right() function in MS SQL vs MS ACCESS
  417. Calling a SP inside a cursor loop..
  418. Calling a SP inside a cursor loop..
  419. Problem with Composite PK
  420. Select multiple rows into one row, MS SQL
  421. Differences between SQL2000 Dev. Edition & SQL2005 Dev. Edition
  422. mysql database session management with cj tracking
  423. MS Excel to MS SQL
  424. Insert trigger
  425. Need help with this select statement
  426. How to get rank?
  427. SQLserver on SBS2003 returns old data
  428. constraint expression for unique keys
  429. how/what should be the query for this result
  430. Datareader concepts to access SQL Server data using datareader.
  431. Scheduling of snapshot agent
  432. right padding equivalent
  433. Help With Syntax
  434. MS SQL date range and average
  435. sorting twice?!
  436. Problem on SELECT statement
  437. Combining 2 tables with date ranges
  438. dbcc reindex issue - - I don't understand!!
  439. Have Insert statement, need equivalent Update.
  440. SELECT statement help
  441. Developer Edition having issues connecting to server via TCP/IP
  442. "Sql Server 2005 Developer"
  443. need tool for managing database object ownership
  444. pulling progress data
  445. Enumerate databases
  446. trigger question
  447. "Ghost" primary key column
  448. I have a question With Related to performence
  449. The single OS nature of MS SQL
  450. EXcel sheet into database with stored procedure
  451. Network error IOException: Could not create socket (SQLState: 08S01)
  452. Insertion and Updates on 20.000.000 tuples table.
  453. Deleted "old" transaction logs = (no items) in EM. How to recover?
  454. Help.... This doesn't make sense...
  455. Access Query against SQL Server works only without criteria
  456. RUN SQL Stored Procedure in Access
  457. The identifier that starts with...is too long. Maximum length is 128
  458. 2 foreign keys to the same table - multitable selection query problem
  459. SQL Server Error "Missing end comment mark"
  460. SuperSocket Info: Bind failed on TCP port 1433
  461. Help sending email
  462. Separate databases for high/low transaction volumes?
  463. Speed up UDF
  464. SQL to Oracle update trigger fails due to distributed transaction error 7391
  465. What is Your Strategy for Upgrade an Access db to SQL Server 2000?
  466. Very Poor Performance - Identical DBs but Different Performance
  467. Query with Joins problem
  468. Extremely Poor Query Performance - Identical DBs Different Performance
  469. Comparison operator in Select list
  470. isql changes null behaviour in mssql 2000
  471. SQL Server 2005 and Cursors
  472. setup multiple SQL server listeners on one machine
  473. SQL server replication from non-clustered database servers
  474. Help with SQL Statement to find first and last populated field in string of fields
  475. Sql Server 2005 questions regarding editing views
  476. Ambiguous Column Names in Multi-Table Join
  477. Problem joining child data (JOIN, subquery, or something else?)
  478. Unable to reinstall Enterprise Manager from original disk: service pack rejected
  479. Ms Access to SQL
  480. Database name with point in it (mail.archive.mdf) not recognised in query analyser of SQL 2000
  481. MSSQL/Related to XML Query
  482. For Xml Explicit//mssql
  483. Concat ??
  484. Ms Access upload to SQL Server 2005 BE & Sharepoint FE
  485. One Database vs. Multiple Databases
  486. Web FE & SQL BE
  487. T-SQL Problem - should I use the "ALL" clause?
  488. SQL 2005: creating "correct" and "incorrect" versions of a database
  489. encryption in sql server 2005
  490. Datatype-convertion in TSQL
  491. Error: 16954, Severity: 10, State: 1 and Timeout problem
  492. SQLDMO - Getting 'Local' Server name
  493. Creating Cursor from Stored Procedure
  494. SQL 2005 - Disappearing Relationships in DB Diagram
  495. help for shrinking database
  496. Sequence generator
  497. DTS copies from SQL Server to MySQL on Windows.
  498. group by
  499. SQL Server 2005 Hash Partitioning?
  500. Left Join variable not valid
  501. SQL Join
  502. ISP Driver Error?Line: 131 of /ips_kernel/class_db_mysql.php
  503. Cannot remove dbo rights from a user
  504. Rebuild index issue - - strange
  505. Connecting Sql Server 2005 from ASP?
  506. How to FAST and EASY ENCRYPTION ALL Stored Procedure in my MS-SQL Database ?
  507. Sybase driver and MSSQL 2k
  508. MS SQL 2000 SP4 Error: 1038
  509. How can I get all records for both tables with the latest begin date if exists?
  510. Stored Proc Question : Why If Exisits...Drop...Create Proc?
  511. Copy text columns to nvarchar
  512. Assistance building a query...
  513. SQL0440N error in Stored Procedure........
  514. Calling another record into this record
  515. how to conver number to string
  516. Debugging in Query Analyser
  517. Are we going right?
  518. out of order identity field - sql2000
  519. Results in Parallel columns
  520. output the latest date for each foreign key
  521. output the latest date for each foreign key
  522. getting the most latest date
  523. Authentication
  524. PArse syslog message into data fields
  525. Create Procedure in an IF block?
  526. Stored Procedure Issue - Problem with temporary tables
  527. Performance issue
  528. enterprise manager (or other software) to document tables and columns for Server2k?
  529. 2 different foreign keys in one table
  530. How to create SQL Server Express server (INSTANCENAME) programmatically?
  531. backup of transaction log
  532. Perfomance Question
  533. SQL server backup and truncate log file
  534. how to specify the column name
  535. A floating point exception occurred in the user process - Msg 3628
  536. 2005: Database cannot be opened
  537. Indexing strategy
  538. Real newbie on SQL ....Know list database and table in SQL Server
  539. use result set returned by sp as derived table
  540. MIN(Count(*))
  541. Create XML in ASP.NET 2.0 then use for joined table in SQL Server 2005 Stored Procedure
  542. SQLDataset.WriteXml and filtering bad characters
  543. output parameters
  544. A basic question: Removing duplicate results from Max function
  545. Project Management Interview Questions June 5th, 2006
  546. Maintaining variable values
  547. Most efficient way to run update query
  548. if-then in select stmnt
  549. collation SQL_EBCDIC037_CP1_CS_AS
  550. Importing data into MS SQL 2000 from XML file