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