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. Query LDAP camUserClasses via SQL Server
  2. SQL Server Case Syntax
  3. Case Syntax
  4. Search for a table/string within job steps, dts, database, stored procedures etc
  5. create constraint error
  6. how to if needed recover from mistake
  7. Is there any array or collections in sql server.
  8. Can one create a view in MS SQL across databases
  9. Why is the trigger locking the table?
  10. INSERT INTO sporadically fails - suggestions for possible reasons?
  11. Count Rows Help
  12. How to fix error 207 in ms sql server 2000
  13. Query Help
  14. SQL Triggers and stored procedures
  15. Composite Foreign Key
  16. select 'message'; not appearing
  17. Issue with Multiple Foreign Keys in MSSQL 2005
  18. updatig sys.indexes
  19. Accessing Remote Stored Procedures using SQLExpress
  20. Extracting data in SQL server using crystal report
  21. Problem with NOT EXISTS
  22. approach to creating a procedure that contains dll , dml to upgrade a system
  23. sorting table
  24. sorting table
  25. 2 IDs profiles from one table
  26. MSSQL
  27. SQL server? MySQL server?
  28. unique filed
  29. /usr/sbin/mysqld: unknown variable 'expire_logs_days=10'
  30. i am not able to connect sql server 2000
  31. Database Owner cannot connect
  32. How to execute all rows in a dynamic query
  33. Get last 5 digits of a 16 digit number - How?
  34. So you think your database is secure? Think again.
  35. TRIGGER after UPDATE
  36. Runtime Error 800a100c!!!!!!!!
  37. Want to make ''Get Latest Status'' function more efficient
  38. UNION SELECT from Multiple Subselects
  39. Subquery returned more than 1 value. This is not permitted when the subquery follows
  40. Subquery returned more than 1 value. This is not permitted when the subquery follows
  41. Passing Parameter Using 'IN'
  42. selecting from 3 different tables
  43. Match exact phrase
  44. Run same query for each day across a date range?
  45. Select trigger?
  46. Moving,Updating and Mergeing in to Single SQL database
  47. Need Some SqlServer Help
  48. Match field and return to "1"
  49. Invalid use of Is operator in query expression 'product is is_clearence=1 and is_visi
  50. Help parsing field
  51. Delta between current and previous row of select
  52. Incorrect Syntax near WHERE
  53. Scoring of returned results with OR
  54. SQL SERVER _ FirePrograms
  55. So you think your database is secure!?
  56. 5-table SELECT giving me problems
  57. Reading SHOW_PLAN output
  58. Date Issue
  59. Stored procedure with if condition on column names
  60. Datetime in Where clause.
  61. How does UPDATE statement work?
  62. delete redundant data
  63. Check Box Value has changed
  64. PROBLEM using CharIndex(), IF, OR etc- PLEASE HELP
  65. Memo field not found
  66. Passing a Parameter through an OpenRowSet
  67. Error 21776 when I change the sa password in sql server 2000
  68. Date function
  69. SQL Server 2000 only using 2GB of 16GB of memory
  70. connecting to Sql Server
  71. Last Day Of Previous Month...with a twist
  72. Combine values
  73. Stored Procedure Times Out from Web Application
  74. Xcopy
  75. Need help in printing the Crystal report in PDF format
  76. Format expression
  77. DBCC INPUTBUFFER results into table
  78. How Import XML file in a table with trigger.
  79. Bulk import a complex XML to SQL2005
  80. calculate commision amount
  81. DB restore question
  82. Narrowed Down Search
  83. Changing license mode
  84. MS SQL Trigger Handling Multiple Inserts Question
  85. Authentication issue
  86. SQL 2005 Job Type subsystem is missing
  87. Number of columns in Database
  88. Output result of query to existing file
  89. How to resolve SQL Server Deadlock
  90. MS Sql 2000 unable to use query analyser
  91. Need help with concatenate Text data field
  92. SQL Query Help
  93. SQL Server 2005 / securityadmin role / SSMS
  94. Extremely Unusual Connection Problem
  95. Web Front End for DTS
  96. how to identify special characters with a single case statement
  97. Inserting ntext into another ntext
  98. Loading data from xml http stream
  99. sql2005/BIDS: getting error 102 with CTE in dynamic query expression
  100. SQL Server 2000 Backup and Restore, Need help!
  101. JPEGs into image column
  102. List of all available sql servers...
  103. new line
  104. Urgent Help
  105. modifying column 'ID'
  106. Sql Server query
  107. Find out last day of the month
  108. Fix Failure result due to no records found
  109. Problem with: Greak characters, superscripts and subscripts
  110. SQL Display Null Values
  111. intersect problem!!
  112. Update a Column
  113. stock control, procedures
  114. Memory Leak in Application running in SQL Server 2005
  115. Update text for a subset of Records
  116. Sorting money with SQL and ASP.NET
  117. Single user mode for Checkdb doesn't work
  118. SQL 2K5 beta 2 setup problem...
  119. Stored Procedure Help For Join Query
  120. MSSQL to Access (SQL Query)
  121. unique constraint on two tables?
  122. How to cancatenate the rows returned by a table-valued function in a sql statement
  123. date comparison
  124. Where conditions, Encryption
  125. Remove Characters in MSSQL record
  126. DataArchitect Version 4.0 now available
  127. Attention All GURUS: Importing Mulitple MDBs in SQL Server 2005 Using SSIS
  128. Importing views from one server to another server
  129. SQL Server Data Type
  130. Mobile Solution with SQL Server 2005 Express edition and smartphone
  131. System objects problem
  132. DTS Job Reporting Failures
  133. Scheduled Jobs failing
  134. Sql Distinct Unique Query
  135. sqlserver
  136. Creating an append query in SQL query design
  137. Using table UDF in a view
  138. what's the correct syntax using DateFormat
  139. Help for Count Query
  140. How To Find SQL QUERY EXECUTION TIME - Very urgent Please Help
  141. SQL query help...
  142. Moving a database
  143. constraint in Trigger
  144. Difference on condition in JOIN & WHERE
  145. sql-problem
  146. create query for crystal report
  147. NULL <> @variable returns FALSE
  148. BCP - help with import/export using collation Chinese_PRC_CI_AS
  149. creating a table
  150. Full Join
  151. Sum question
  152. Naming Conventions
  153. Merging two rows within same table
  154. Specific deadlock problem
  155. SubSelects to JOINS
  156. Log File Problem
  157. import data
  158. Displaying Data Across when data goes down! Has to be easy!
  159. Catastrophic failures with linked servers
  160. Suggestions on how to convert MS Word Data Dictionary to SQL Server "Description"
  161. One trigger, many tables - how to automate?
  162. INSERT - one record at a time
  163. Crystal Rpts Help- Dates
  164. Update every row Column_3 = Column_2?
  165. SQL Stored Proc Executing Another Stored Proc with Multiple Values Passed
  166. Trying to use a batch file to run a DTS program
  167. FYI: Maximum # of indexes
  168. SQL Enterprise Eval => SQL Standard
  169. Visual Studio - process task & Continue without completion
  170. Create table as copy of existing table
  171. Create Table Syntax
  172. what is mirror table in sql server
  173. MSDASQL problem...
  174. DELETE query criteria
  175. SQL 2005 Express dropdown
  176. Getting Execution Time of a SQL QUERY through Dot Net
  177. Problem with procedure
  178. UNION Query
  179. changing IP addresses of MS SQL server in clustered environment
  180. Need to tune a table for performance gains
  181. Dynamic SQL reading statements from table
  182. Need help w/ sp_send_dbmail !
  183. Binary Value Manipulation
  184. Pivot data - with dynamic headers
  185. SQL help name conversion
  186. How can I execute a program from a Stored Procedure
  187. Need to go down path to find if everything is settled (recursive possibly)
  188. How do I sum the values of a column?
  189. SQL quiz
  190. ms sql server 2005 standard edition
  191. Create table using joins
  192. MSDE remote connection failure
  193. MSDE Performance Degredation
  194. Query help: Item below reorder level-find all items for same vendor
  195. XML Templates and Redirects
  196. Completely Stuck Importing Data to SQL 2005
  197. Error Converting Data Type NVarchar to Float
  198. not coming what i want query from two tables
  199. Compare Previous and Next Records
  200. Replicating database btw two sites why aren't the tables identical in size?
  201. Create One Trigger For Both Update and Delete
  202. Yellowfin Version 3.2
  203. Oracle 9i Database Administration in 10 Minutes
  204. How do I import Excel file into SQL Express???
  205. Triggers
  206. retrieve data from sql2005 in C#.net
  207. SQL Server Annoying popup upon boot
  208. Transform/transfer 50Gb - how to do it fast?
  209. Active Directory select
  210. SQL Server Stored Proc Issue with Java
  211. How to display last record entered with select query ??
  212. Help Please: Creating Transaction Log Backup
  213. Linking SQL server 2005 and Oracle 8
  214. How to Get 4th Largest salary without using "join" or "where" in SQL ?
  215. Creating a Loop to Insert Integers into a Table
  216. Many Databases on One SQL Server
  217. LOG Explorer
  218. MS Sqlserver 2005: Displaying only dbs user has a right to?
  219. MSSql VB ADODB troubles
  220. SQL server, Image data type pointer
  221. error to send mail using xp_smtp_sendmail
  222. Time part Problem
  223. Unable to retrieve data when using Greek characters in statement
  224. Transaction Log Backup in Bulk-Logged Recovery. help asap
  225. Microsoft JET Database Engine
  226. convert number to text
  227. Joe Celko coming to Seattle
  228. SqlCacheDependency based on what notification event??
  229. MSSQL query
  230. Database Mail: getting bounce info from Exchange?
  231. Database permissions possibly?
  232. Database Mail: detecting undeliverable from Exchange?
  233. Denormalized Database Inquiry
  234. How to Generate all grants to a user role? (SQL Server 2000)
  235. Updating a table if another tables row matches... not sure if that quite explains it.
  236. OPENQUERY UPDATE Syntax help needed
  237. how to use sp_cursoropen
  238. Monitor Object Access
  239. OPENQUERY UPDATE Syntax help needed
  240. getdate() problem: where is the time taken from ?
  241. Populate a Table with Stored Proc.
  242. Number of columns and performance
  243. How to get Recovery Model of a SQL 2000 Database?
  244. Upgrade
  245. Upgrade
  246. selecting the last 3 orders made
  247. T-SQL Debugger Error
  248. T-SQL Debugger Error
  249. T-SQL Debugger Error
  250. SQL2000 - Table Collation Error
  251. what is the difference between unique constraint and primarykey and identifiers
  252. Optional Where Parameters on Null Data
  253. MSSQL Audit using ArcSight
  254. About DateTime in SQL
  255. sql script
  256. How to Generate all grants to a user role? (SQL Server 2000)
  257. Regarding sql error
  258. Populate table with stored proc
  259. Microsoft SQL Server 2005 JDBC Driver 1.1 on Solaris
  260. MS SQL Server Slower for Persistant Queries
  261. Modifying SQL Server 2000 Maintenance Plans through Scripting
  262. Generating XSD Schema straight from SQL Server Management Studio
  263. Problem with Check Constraint Validation in MS SQL Server Management Studio Express
  264. Different UPDATE behaviors across servers
  265. Trigger: To fill another Database with using Stored Procedures of the other Database
  266. Having difficulty setting Back Up to back up file wihout datetime stamp SQL 2K
  267. SQL Server Integration Services please HELP
  268. How to call a function from a column formula in my MS SQL table
  269. questions about a View with a Where clause
  270. Transposing rows as columns
  271. MS SQL 2005: DB Mirroring and Log Shipping
  272. Assessment of Database Stored Procedures
  273. Failover Cluster not using all allocated RAM
  274. Upgradation
  275. Question about move large amount of data from database to database
  276. sql select problem
  277. READ UNCOMMITTED data
  278. Update trigger or ?
  279. how to update a column by using 2 or 3 tables ?
  280. Sql Server Import
  281. Restore database in SQL 2005
  282. COUNT many but display just once?
  283. Unexpected LIKE behavior
  284. About calender week
  285. MSSQL: ALTER TABLE in PROCEDURE
  286. Garbage at the RowEnd
  287. how can i go about executing these querries using joins?
  288. joins syntax
  289. Return Max Value from SubQuery
  290. Return Max Value from SubQuery
  291. Query Optimization
  292. timestamp ans status of database file
  293. complete NOOB hope someone can point me in the right direction
  294. differences between stored procedure and cursor
  295. Accessing COUNT(expr) values
  296. dbcc dbreindex question
  297. Interesting SQL problem : How to track movement history
  298. combining rows into a single row output
  299. flattening multiple source measurements into a single fact record
  300. SQL Select Question
  301. KILL Command in MSSQL Databases
  302. Check if record is full-text indexed
  303. Adding users to linked server
  304. Optimized SQL Pivot type query
  305. Function Parameter
  306. Cursor for a result set returned by a stored proc
  307. Comprehensive Index Information
  308. Net Address - bogus values
  309. C# connects to SQL Server Database
  310. Looping Through SQL Values
  311. SQL Server Integration Services HELP URGENT
  312. SQL Server Integration Services - Foreach Loop Container HELPPP
  313. FORMSOF and variable
  314. Visual Basic InterDatabase command keeps displaying Select Data Source screen
  315. Can I use C# Code in SQL Server Integration Services -Script Component Manager
  316. RESTORE DATABASE is terminating abnormally.
  317. SQL Server Integration Services HELP - URGENT
  318. Column naming/spacing
  319. Error Message: database has exceeded threshold of 85%
  320. Disabling or Getting Rid of Foreign Keys So I Can Drop My Table
  321. Backup Names
  322. SQL Write Access to Shared
  323. Snapshot of databases = Hourly job
  324. what is differences between cursor and stored procedure?
  325. What is cursor? How many Types of cursor? how to create each one?
  326. Sql
  327. The function Len; maybe a solution
  328. SQL server 2000
  329. Sql server error
  330. How to do a Join Using Foreign Keys in Stored in a Database Column?
  331. Changing collation types and the indexes that love them.
  332. questions on SQL Profiler
  333. DB Replication or Table Replication via triggers?
  334. Anyone lend a hand in .NET?
  335. how to use a SQL view as a data source for Excel file
  336. Bulk Insert: Unexpected end-of-file (EOF) encountered...
  337. Combining queries
  338. how to generate reprot using sql server 2000 reporting service
  339. How list out all tables in MS SQL?
  340. cronjob on ms sqlserver
  341. converting data(varchar & float) to money
  342. Very big table
  343. Strange error on linked server - cannot open default database
  344. How to copy a sql server database to disk
  345. Problem in creating Crystal reports
  346. default datetime argument in stored procedure
  347. Tranaction log error- can someone tell me if this error was my fault
  348. Problem in creating Crystal reports
  349. What is better to use?
  350. Yellowfin Argues Embedded Business Intelligence Is The Future.
  351. hiearchy in sql
  352. At my wits' end: LIKE
  353. Keyword Density/Count
  354. Update Last Record
  355. Access to different databases in different domains
  356. SP_TRACE_CREATE in MSSQL 2000
  357. Rants. Difficulty to learn ETL tools?
  358. AL-USA-PHP/DATABASE WEB HELP
  359. AL-USA-PHP/DATABASE WEB HELP
  360. Date problem
  361. sql server2000 how do i stop running a stored procedure
  362. Dynamic order by
  363. Paging and dynamic sort order (ASC/DESC)
  364. Need help writing a query
  365. SQL Client 2005 on Win98
  366. Database Mirroring Monitor Job Error
  367. sqlconnection open state
  368. execution plan for single stored procedure from profiler
  369. Problem with date parameter in stored procedure
  370. Virtual Cube Hanging When Retrieving Data & Doubling Up Problem
  371. Null value
  372. idea for database system application
  373. how convert date to string
  374. ssis - Export to a file and Rename file
  375. Filter records during Transactional Replication.
  376. WinCMD job
  377. XML Error message: Name cannot begin with the '.' character, hexadecimal value 0x2E
  378. How to Filter condition while Transactional Replication
  379. How To Return A "Range Of Rows"??
  380. Many tables or a big table with views
  381. Theoretical definition for the number of unique values?
  382. Theoretical definition for the number of unique values?
  383. possible to call php web service from sqlserver/mssql
  384. Problem to insert Display date
  385. Problem to insert Display date
  386. RESTORE DATABASE ... WITH PARTIAL
  387. RESTORE DATABASE ... WITH PARTIAL
  388. ODBC Query ... getting Where Clause
  389. [help SQL SERVER] Query
  390. Msg 102, Level 15, State 1, Line 3 in Sql 2005
  391. Trigger Problems
  392. teradata-java
  393. Extol Chooses Yellowfin Business Intelligence for its neural predictive analysis appliance
  394. record insertion from muliple sourses
  395. Avoiding UNIONS
  396. Submit Resume to 10,000+ Corp-Corp Recruiters
  397. Work with 10,000+ Corp-Corp Recruiters and share Resources
  398. For Loop
  399. Negative and Positve data from Sql
  400. Sum of Column of Blob type
  401. create DBF files using SSIS
  402. Retrieve ALL tables from ALL Databases
  403. How to find out MSSQL 2000 or 2005 ?
  404. Retain/expiration inside a backup device.
  405. SQL Server Performance
  406. looking for a query
  407. Split a string into multiple fields
  408. How to display one field from 2nd table on the 1rst table?
  409. change formula thru SQLServer
  410. How to keep tables updated that are imported from other database
  411. How to join tables in different databases
  412. Stored procedure returns duplicates
  413. The SQL Server management pack script "SQL Server 2000 Database Health" is unable to
  414. Simple query for MSSQL
  415. Bulk Insert with default value
  416. SQL Query using 'OR' Causing problems
  417. Best way to export data.
  418. Problem with replace function
  419. SQL Select Command - Partial Variable String
  420. Help needed for datediff function for SQL query
  421. MSSQL Profiler
  422. SQL - Foreign key with references of multiple tables with same primary key field
  423. Storing records
  424. transferred database
  425. SQL Help - avoiding querying a query...
  426. help needed with update trigger in SQL Server 2005
  427. Convert SQL Account to Windows Accounts + EXEC on ALL SPs
  428. problem in connection of sqlserver with netbeans IDE
  429. How to Delete Duplicate Record in sql server 2000
  430. Inner Join Not Exists
  431. Query Help.
  432. Do I need to install SQLXML?
  433. Limiting results to 3 most recent ID's for a group by...
  434. unable to begin a distributed transaction (Msg 7391)
  435. MSSQL with one or more users
  436. Cursors and Strings to Create a table with two columns
  437. cursors with where clause
  438. More XML query questions
  439. Performing calculation using two rows from the same table
  440. select distinct record only if certain column not null
  441. Error import
  442. Sql Server inserting into z/OS db2 table
  443. FOR XML PATH and dynamic attribute names
  444. How to import apache log file into a table in SQL 2000
  445. I am new for SQL Server please help me to write the code
  446. ChannelAdvisor - DBA Openings
  447. sql server 2000 and distribution
  448. Analysis Manager -copying of databse roles?
  449. MSSQL 2000 and MSSQL 2005 servers run in the same desktop machine
  450. Identifying Repeating values in a string
  451. Update Query
  452. database transfer
  453. Storing Many Fields in a application to one field in table
  454. Capture NT User ID
  455. Urgent help with default value Or Binding MSSQL
  456. Compact and Repair in an adp
  457. How to read second record within XML file by using openxml?
  458. Logging Rows Processed by various stored procedures within a DTS package
  459. Intermittent OLE DB connection problem -- SQL 2005 SSIS
  460. Help with parsing assigned groups and roles
  461. Combining Fields to string
  462. Splitting a field into multiple rows
  463. SQL Server 2005 full backup script
  464. SQL Pagination With Dynamic Order By
  465. Users cannot view stored procedure text
  466. SQL Server
  467. setting up asp server on xp home
  468. Compare to fields from two different tables with same structure
  469. Backup /restore DB
  470. writing the trigger on text field table
  471. Create Temp Table for getting max date
  472. Download Merlin Data Compass 2
  473. Difference between Full Join and Inner Join in SQl Server 2005
  474. Need Assistance with Dynamic Properties and FTP Task
  475. if statements in SQL Query
  476. xp_CmdShell
  477. clone MSSQL server 2000
  478. SQL question
  479. SQL Server 2005 and ASP.NET
  480. GUID's as a partitioning column.
  481. need one record from one table based on list in 2nd table
  482. SQL query help
  483. How to update selected columns of a table in SQL server db using data from a Excel file?
  484. Regarding DTS
  485. indexes and query optimization
  486. stored procedure help pls
  487. Bulk Insert Failure on DTS 2005
  488. Query queued
  489. Different Types Query
  490. Cascade 2 strings in stored procedure for MS SQL
  491. SQL Express 2005 Vs MSDE
  492. Problem in Creating AFTER INSERT Trigger
  493. MSSQL Questions - Images and Frontpage integration
  494. sum of derived value?
  495. Multiple counts(*) returning 1 record
  496. Naming The Database Server(s)?
  497. SQL database auto grow
  498. SQL server 2005 Express - Vista - Invalid object name '#spdbdesc'
  499. Sql Syntax Error!
  500. Linked Server and FilemakerPRO
  501. Linked Server and FilemakerPRO
  502. Pass XML file to SQL stored procedure
  503. Pull info from Active Directory into SQL Server 2000
  504. join the same table more than 3 times
  505. SQL Datatypes
  506. The old inability to toggle/change/switch between ALTER PROCEDURE <---> CREATE PROCEDURE bug (or is it a feature?)
  507. Combine of 2 queries from different Tabled
  508. hi this is dileep
  509. Where r SQL database tables stored ??
  510. Copy the Database Structure to a new DB
  511. How do I save a query result to a new table?
  512. how could I ???
  513. Converting a date field to the month
  514. DTS SQL JOB hangs even after the successful completion of the DTS
  515. Allowing users to truncate log file
  516. After Sql 2005 Install, Sql 2000 Still There
  517. I have a database on a network drive that I use for archiving purposes, but when the server is rebooted the database becomes suspect.
  518. Database Synch. Problem using i'net
  519. Data type in audit record
  520. BrainDamage
  521. log shipping
  522. getting error while installing sql server 2000 reporting services
  523. Backing up MSSQL Server on Windows 2003 Small Business Server
  524. SQL Trigger
  525. Combine multiple records into single row
  526. SSIS PAckage Hangs
  527. Log Shipping Issues
  528. pivot table without aggregation?
  529. Getting the results for month and year by a single SQL query
  530. Stored Procedure
  531. Cannot convert from varchar to bigint
  532. hi
  533. Run query based on values in another table
  534. Restoring backup from SQL 2000 to SQL 2005 but login name is missing
  535. Need help in writing a Stored Procedure
  536. Using OPENROWSET to import a textfile
  537. Store and retrieve objects - Please help
  538. USING BULK INSERT to add data to existing tables
  539. "cursor" what is that
  540. SQL Update HELP!!!
  541. Count and Compare 2 Tables
  542. connections
  543. Delete Time out of Date/Time column
  544. problem in searching data from sql
  545. Flat file source import to SQL databse
  546. Database Mirroring Transport is disabled in the endpoint configuration.
  547. Release Dates
  548. Cyrillic number
  549. Return Record Number with query
  550. data length more than ...