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