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. Timeout Expired Error
  2. Monitoring Data file size
  3. don't permit manual access to database
  4. Splitting of database
  5. Frontpage 2002 & passing an SQL variable
  6. Snapshot replication
  7. SQL - query improvement MAX(date), IN
  8. Problem with dbo.sysindexkeys in SQL 2000
  9. Creating a trace file with the date appended to it's name
  10. Help with DTS script
  11. SQL Server & MSDE on same machine?
  12. Linking Two SQL Servers
  13. Can I ghost an SQL server?
  14. Tables get Locked
  15. Count of related records??
  16. MS SQL 2005 Express
  17. Net Send Failure
  18. Monitoring Deadlocks
  19. Best way to create dynamic update statement
  20. Job openings for scientifically-oriented programmers
  21. Edit .mdf database
  22. importing a .txt file
  23. SQL Backup procedures...
  24. Installing MSDE2000 for Remote Connection
  25. Noob: Why does this Query work?
  26. concatenate where clause
  27. Moving db across the country- full copy, then differential?
  28. Inserting Records with limited privileges
  29. Scripted delete rows
  30. SCOPE_IDENTITY with ASP
  31. A query that chooses non-matching items
  32. Counting based on a field combination
  33. SQL Server Hot Fix Install Error - dbmslpcn.dll is WRITE LOCKED
  34. Enterprise Manager Collision
  35. Views Are Deleted
  36. quey help
  37. Storing a month
  38. Storing a month
  39. problem with OUTPUT params in Stored procedure
  40. not exist in place of outer join
  41. Dates incorrectly being saved incorrectly. DD and MM swapped round ?
  42. Primary key on combination of nullable fields, at least one not-null
  43. SQL statement
  44. create database at shared hoster site
  45. SQL datetime from incorrect char(10)
  46. Refresh data from production to development
  47. Interesting Problem
  48. SQL Server on Windows XP Workgroup
  49. paradoxical query results?
  50. Int versus Char primay key performance
  51. Tables seem too big - timeouts happening
  52. SQL Server Distribution Server Licensing
  53. SET FMTONLY being added to in-line SQL
  54. Proyectos de Inversion en IT en la UTN
  55. what does [dbo].[Accounts] mean?
  56. web hoster only allows 1 sql server database
  57. problem in registering sql server in enterprise manager
  58. query result as comma-separated list
  59. Last edit time?
  60. Installation Issue
  61. compare
  62. Question with filegroups
  63. help with query
  64. I need help connecting Access 97 to SQL Server 2000
  65. IsNull Evaluation within EXEC
  66. Parameters in Reporting Services
  67. Database Environment Naming Production -vs- Development
  68. restore from command line
  69. SQL to find short, fat and stupid people
  70. Strange Problew with user defined function or stored procedure
  71. Get lowest date
  72. How to reinstall RS Standard Edition on top of expired RS Eval edition
  73. Format display of current row
  74. Connecting Access Front End to Remote SQL Server
  75. Connecting Access Front End to Remote SQL Server
  76. Modifing the row that invokes a trigger from within that trigger
  77. instead-of trigger and contraints
  78. Advantage of Temp Table
  79. VBScrip Type Mismatch Error
  80. Diagram of Master DB
  81. Linked Server gives Internal SQL Server error
  82. prevent DELETE and/or UPDATE
  83. binding SQL server to localhost?
  84. Would you please suggest a good backup tape drive?
  85. Cache HIT ratio problem
  86. Verify dynamically specified table exists
  87. command line
  88. DBA HELP: Performane Tune SELECT, SUM, & CASE
  89. QA tells me my table is ambiguous
  90. Breaking up a Table
  91. Call DTS package from VBA/Excel?
  92. query analyzer returning messed up data
  93. MS SQL Server 2000 / MS Access - ODBC connection question
  94. Lost My Diagrams
  95. New SQL Server and Photos
  96. I dont have any backup of my database, but I have the mdf's and ldf's files
  97. How to get parameter passed to SQL query from access
  98. Creating a view from a linked server
  99. How to comment a server template
  100. How do ITables moved to a new FileGroup ?
  101. Sum of hours by week
  102. Destination Columns Question
  103. Remote access to sql database...permissions
  104. Using MSDE and moving databases
  105. Help! Cygwin X slows down Query Analyzer
  106. How to copy db from test server to local machine running MSSQL2000 Per.
  107. Inserting a record for each separate aggregate (solved)
  108. Import RIS format to SQL Server?
  109. Run DTS in safe way.
  110. Neq to SQL
  111. How to fetch or store a BIGINT using dbExpress and Delphi 2005
  112. Deadlocks in Profiler
  113. DBCC SHOWCONTIG inconsistency????
  114. Access Violation on Saving a DTS Package
  115. Assistance developing Query
  116. Convert variable into dynamic select
  117. Windows groups for SQL Server - what am I doing wrong?
  118. Run DTS package
  119. Primary Key
  120. Move mdf/ldf files for a replicated database
  121. Gather Meta Data
  122. Checking datatypes of a field accoss multiple tables
  123. How to call functions via ODBC
  124. Learning SQL Server 2000
  125. Date problem in SQL Server
  126. Data Parsing in SQL Server views
  127. Changing collation for tempdb and model
  128. Changing collation for tempdb and model
  129. Changing collation for tempdb and model
  130. Design Problem...Please Help!!
  131. Char to Bit
  132. SQL Server Agent - E-Mails
  133. Help with update query linking 3 tables
  134. sp_configure missing - need to allow updates!
  135. Alias has confused me.
  136. sp_configure missing - need to allow updates!
  137. time-series SQL code.
  138. Log Shipping Transaction Log Question
  139. 100,000 lock requests/sec
  140. [TRANSACT]Can't switch from master to another database
  141. SQL Server Query Optomizer
  142. "Users shopping for A were also interested in B"
  143. xp_logininfo and Domain Local groups
  144. "Unable to validate product key"
  145. Help with JDBC Driver
  146. Object Owners.
  147. Compare data in Tables
  148. MS SQL Server 2000 Log Shipping problem
  149. Getting error c:\windows\system32\odbcad32.exe error
  150. International Motivation Survey
  151. Need one Query to obtain results I can only get with two queries
  152. Transaction Replication & Data archiving on SQL server 2000
  153. SQL gurus, please help
  154. Connection problem from Access front end application to SQL Desktop Engine backend
  155. Strage characters displaying in Enterprise Manager 2000
  156. Return Type of COALESCE?
  157. Strage characters displaying in Enterprise Manager 2000
  158. Using DTS Global variable in task
  159. Creating a Select statement with subqueries to 3 other tables...
  160. SQLDMO - Operating System Cannot Run %1
  161. Microsoft Access doesn't support design changes to the version of Microsoft SQL Server
  162. Seaching mulitple fields?
  163. Importing txt files with sql server 2000
  164. Do's and Don'ts of SQL
  165. Reorganize data and index pages
  166. Unhandled exception in mmc.exe: : Access violation
  167. How to solve "Tables or functions 'inserted' and 'inserted' have the same exposed names. "
  168. Openings in an online game company for sql coders
  169. Return results of mulitple select statements in another Stored Procedure
  170. Query runs slower when converted to a view
  171. Poor performance for business day calculation from aspfaq sample
  172. Limiting active processes?
  173. Database design
  174. Delete with 2 keys
  175. Example of Internal SQL Server Error
  176. SQL Server Best Practice Analyzer and T-SQL coding standards
  177. Merge results from two fields
  178. Big table
  179. Problems with joins
  180. How to assign string value to TEXT output parameter of a stored procedure?
  181. Using an if statement
  182. parameterized pass-through queries from Access front-end?
  183. Optimization of a select query
  184. Maintenance Microsoft
  185. A little script help
  186. SQL Server Backup Applications
  187. HELP PLEASE. Query Question.
  188. Help with a Join and Duplicates?
  189. How to extract part of a string
  190. How to upgrade a stored procedure this way?
  191. SubQuery or Temp Table?
  192. Help with dynamic SQL Stored Procedure
  193. Database Design
  194. Inserting data to tables belonging to different databases
  195. howto check the sql server edition from code
  196. Paper about SQL Server 2005
  197. New to MS Sql
  198. Data transfer
  199. Convert a existing SQL Server 2000 database to 2005
  200. System DSN / Registry
  201. SQL SERVER DBA/ ATLANTA
  202. relation & query
  203. remote stored procedure on MSDE
  204. Fastest way to handle the search
  205. naming column names
  206. help on query
  207. MSDE installation fails due to detection of previous installation
  208. Table size and Computed Columns
  209. trying to avoid using cursors!
  210. How to Go From a Database to A Calendar Format?
  211. Help with 1205 Not raised
  212. cursor vs. select
  213. ASP + SQL loads really slow over intranet
  214. Insert produces error
  215. HELP - SQL Server 2000 Install Files needed urgently
  216. User input in SQL2000
  217. Can stored procs run after handle is closed?
  218. Restore Log Fails Msg:3433
  219. Date Display
  220. Error on link Servere
  221. How to add 2 columns together
  222. Dev. Team - Keeping Three Tiers in Sync
  223. SQL 6.5 migrating to SQL 2000
  224. Import XMS into SQL Server 2000
  225. NTEXT vs NVARCHAR for large number of columns
  226. Crear una BBDD desde VB.NET
  227. Memory Mgt in SQL SERVER
  228. Enterprise Manager Date format has changed
  229. Copy a database
  230. loop through a datagrid
  231. How to backup a database into a number of smaller files ?
  232. SQL Like.
  233. MS ACCESS - ON DELETE CASCADE Problem
  234. Query Optimization
  235. sp_send_cdosysmail - Parameter Inside Body of Email
  236. can't do that request
  237. owner of a temp table
  238. Accomodating 'Dummy' Data?
  239. Problem with query and date ranges
  240. Error processing cube with disabled lowest level of shared dimension
  241. Locking Problem: SQL Server
  242. isql error message
  243. How to copy tables from local machine to remote SQL server
  244. Dynamic Build SQL in store procedure based on select
  245. Is it ok to use 100% of SQL Server CPU?
  246. bcp is inserting blank space for empty string
  247. SQL 6.5 - to - SQL 2000 replication
  248. parse XML strings in SQL text field
  249. 3 quick queries
  250. Insert value in an auto-identity column
  251. My db grew 8.2GB in two weeks BUT only 4MB of data added
  252. INSERT violates primary key. Which way out?
  253. Cannot Generate SSPI Context
  254. Distributed transactions with multiple instances of Microsoft SQL Server
  255. email on insert
  256. Enter Default Values for all columns in all tables except Primary Keys
  257. update fields with searched first date record fields
  258. SQL Query Help
  259. Re-using a calculated sub-select field in a view?
  260. What is wrong with this procedure?
  261. help with santax
  262. How can i copy data
  263. Copy field data from table to another
  264. ((((((((( Can someone post SQL 03 program ))))))))))))))))))
  265. (((((((((( Anyone know where I can pickup MS SQL 02? ))))))))))))))))))
  266. NULL values and Indexes
  267. Installing Without CD - Help
  268. Obtaining business hours based on start and end date
  269. Domino VBA
  270. Domino VBA
  271. Is Physical server name stored in the Master database
  272. Renaming logical file names
  273. Utilizing compound indexes
  274. Selecting single sorted row from many column
  275. Converting tables to Upper case
  276. Profiler Trace file format
  277. Join using max value
  278. ZZZZ New text 1/1 New Text Document.txt (1/1) 18
  279. ZZZZ New text 1/1 New Text Document.txt (0/1) 18
  280. filelistonly vs verifyonly
  281. How to connect using C#
  282. audit trail triggers
  283. Checksum not working
  284. Exam 70-229
  285. exec sp_executesql vs. sp_executesql and performance
  286. Need help in Updating multiple rows
  287. CHECK Constraint to prevent a conditional duplicate
  288. Transaction MS SQL
  289. SQL Enterprise Manager and Query Analyzer displaying different Row Counts
  290. Database definitions
  291. urgent
  292. Oledb stored procedure rowset binding
  293. GROUP By clause or DISTINCT clause
  294. Specific Book Recommendation
  295. Question on using patindex
  296. Server not using all available memory.
  297. Grouping columns
  298. Importing Access databases into SQL Server
  299. What is Cardinality
  300. 'Suspect' DB won't open - OS error 32- Help!
  301. Inserts gradually slow down
  302. SQL Union with ORDER BY
  303. Need help with complex(?) querie
  304. isqlw.exe
  305. Restore Production database to Development
  306. Duplicate Reference Numbers using MAX()+1
  307. sql charindex split string
  308. Determine Quarter End and Beginning Dates
  309. owner data objects
  310. Transaction log shrinking... weird behavior?!?!?!?
  311. SQL Server: command line support
  312. Connecting to SQL Server 2000 on another subnet
  313. Front-end website search using Full-Text
  314. Count consecutive numbers
  315. local data
  316. .RMD or RMX. to sql server
  317. Which is better? Int or smalldatetime(MSSQL)
  318. SQL Server 2000 and Windows Server 2003
  319. a new SQL tool to help maintain SQL code is now out
  320. Many databases vs. 1 database
  321. a new SQL tool to help maintain SQL code is now out
  322. Restore database fails because database is in use.
  323. More on mysterious data loss in mssql2k - a possible solution?
  324. read only database performance question
  325. Dynamic Column amount query
  326. Can someone explain this behaviour?
  327. top keyword and sorting
  328. can't do that request
  329. Count the number of cubes
  330. Column Names with a cursor
  331. Sample ASP Script??
  332. Database backups growing exponentially
  333. sql service run as question
  334. How To PROTECT SQL Server Database Files ?
  335. Database Move
  336. Mysterious loss of data from mssql2k
  337. Great News Blog!
  338. Having Trouble Installing Reporting Services
  339. Query problem
  340. Help with query
  341. Interesting issue with Full Text Search
  342. Tough little trigger
  343. SQL Server Performance
  344. Need help with SQL query
  345. Virtual Server 2003 Issue! Access Denied- Admin web screen !!
  346. Process not getting any memory
  347. Dropping FK Constraints in a Stored Procedure
  348. C#, SQL-DMO, Add FileGroup Issue.
  349. Insert SP results into variable?
  350. No longer need default instance of SQL Server
  351. basic sql question
  352. SQL Server 2000 Table Auditing for HIPAA
  353. Log Shipping Problem
  354. sql server replication performance
  355. Recursive Query ??
  356. Getting SUM Function Result
  357. Executing sql statements
  358. Syntax for updating table variables
  359. Handle SQL errors with severity 10
  360. Timestamp problem!
  361. Error 15401 adding login to SQL Server
  362. SQL database structure question
  363. How display number records in query designer VisualStudio.NET
  364. help on a sql request
  365. Views / Stored Procedures / Updating Records
  366. Compairing updated data base.
  367. Calling Encrypt2 function from Sqlserver select query
  368. manage transaction to avoid locks
  369. Virtual Primary Key = Slow
  370. SQL Server Scalability
  371. SQL Mail
  372. Help! SQL Server error - [Microsoft][ODBC SQL Server Driver][SQL Server] Invalid object name ...
  373. access 03 query datashet view problem help
  374. Combine two queries - help please
  375. Import Password Protected File Via DTS
  376. using count somehow
  377. Is it possible to write a format file that skips a few bytes of header in data file?
  378. How do you export?
  379. Dataset Code Debugging
  380. Altering functions and CHECK constraints
  381. Results of SQL SELECT statement into Stored Procedure
  382. Server Reboot
  383. Replication Problem
  384. View Optimization?
  385. SQL Connections using NAT
  386. C#: Running DDL to Create Functions.
  387. Updating a field for multiple records
  388. search engine in SQL server ?
  389. slecting a table using a local variable name
  390. Need help with query that does both timediff & sum
  391. copying data and structure from one database to another
  392. Please help: Create View
  393. Please help: Create View
  394. stored procedure question
  395. Inserting multiple rows with a single INSERT INTO
  396. Cacluated Field
  397. smalldatetime and sorting
  398. Derived Fields
  399. To compare fields between two table
  400. union with sub query
  401. Data import - foreign key question
  402. urgent DB export issue
  403. Vote on a new newsgroup proposal
  404. Windows 2003 - SQL server does not exist or access denied
  405. T-SQL Help
  406. Unable to create a step in a SQLServer Job
  407. Can't connect to SQL Server (developer edition) from another PC?
  408. Help with java connection to MS SQL 2000 with windows integrated security
  409. automatic rename in FROM clause of dependant objects ?
  410. typical audit trail ?
  411. difference between SYSTEM_USER and USER
  412. How to find max from a table by row
  413. HELP: REGEXP accurences count
  414. Inserting to table with dashes in fieldnames
  415. Calculate/create Row Number without identity
  416. sp_attachdb time varies
  417. Exists query with priorities
  418. Date range problem
  419. BCP and Bulk Insert to Linked Servers
  420. How to simplify my endless query. Thanks.
  421. question on trigger/procedure plz reply?
  422. Question on FOR XML issue
  423. sql query help
  424. Help with SQL if statement and adding fields together
  425. treat contiguous records as 1
  426. quick question on SQL server and object support
  427. Null How to handle
  428. Stored proc location
  429. Table Design Question
  430. Change data type during INSERT INTO ?
  431. Urgent
  432. Finding last "whitespace" character in a string?
  433. Question on Idenity Columns
  434. How to handle this Linked Server error trap in SQL2K?
  435. Parse a numeric string from a field
  436. Setting up backups
  437. updateblob
  438. Switched to simple recovery model when will the transaction log shrink?
  439. limiting result set from MS SQL Server Query
  440. How to get info in SELECT directly instead of UPDATE? Thanks.
  441. Can you qry sys tbls to find Triggers, Constrants etc?
  442. How to build database to support user-specified entities and attributes?
  443. Poor performance
  444. working with xp_sendmail
  445. AND query in single column
  446. Stopping a script
  447. How to get a batchjob to run on more than 1 processor ?
  448. SQL Query to return rows only when a max limit on SUM has been reached.
  449. dynamicall execute SP without dynamic sql
  450. Get next unique ID from a table before insert @@identity / Sequence
  451. Sum fields
  452. Exatract Data, thanks.
  453. change license mode on SQL 2k cluster
  454. change license mode on SQL 2k cluster
  455. How do you execute an Oracle Stored Procedure from a SQL Server DTS package?
  456. Query help -- extract data, thanks!
  457. Other than UNION
  458. isnull and ntext variables (short question)
  459. Easiest way to copy a MS-SQL Database from one machine to another
  460. "IN" clause limitation
  461. change to not allow nulls
  462. Converting DateTime
  463. EXEC stored procedure for every line of SELECT result table - how?
  464. Help with WHERE Clause in Stored Procedure
  465. sp_executesql & Output Variables. One Ball#$#%% of a problem.
  466. rollback via query analyser
  467. Handling Schema Changes
  468. Trigger
  469. BULK INSERT - does it lock the file while reading?
  470. How to convert from ntext to float?
  471. REPLACE ISSUE..
  472. SQL Server 2k - Timezone question.
  473. Updating the same column multiple times in one update statement
  474. Repeating Records!
  475. SQL Server DBA needed for Florida-US
  476. How to apply complex constraints
  477. SQL Reporting Services PDF Chinese Characters Problem
  478. Simple SQL help needed
  479. How to compare Binary and Int colns
  480. Performance -- count(*)
  481. How to build database to support user-specified attributes?
  482. Moving a database from one machine to another and the lack of speed
  483. query to fetch data
  484. Replication Question about job names and categories
  485. External Access
  486. Very unhappy front end developer looking for advices
  487. Record count in all tables
  488. Can SQL Server 7.0 handle a SQL Server 2000 mdf?
  489. low cost method to check database before inserting data
  490. Import data from Adaptive Server Anywhere 7 DB
  491. MULTI-Table Update Queries
  492. stored procedure varaiables
  493. Code page translations are not supported for the text data type. From: 1252 To: 950.
  494. Active directory query 1000 page size limitaion
  495. Java against SQL Server
  496. SQL Server 2000 vs. MSDE
  497. problem making Oracle linked server work
  498. Need Trigger Help
  499. Using Access with SQL Server
  500. trigger event after time period
  501. IF..ELSE in function - unknown error
  502. CHARINDEX and STUFF/REPLACE
  503. Db installation
  504. long time to establish a connection
  505. Connection string for the Ms-SQl Server using ASP.net
  506. Question: changing case on existing records
  507. SQL Server 2000 Book Recommendations? Including Good Coverage of Reporting Services
  508. Pivot Chart Value Axis Scaling Question
  509. Sql query timeout, expensive cast operation?
  510. Single complex INSERT or INSERT plus UPDATE
  511. Outer Join - shifting result set.
  512. How does SQL 2000 Server back up user database?
  513. creating a new numbered column as primary key in a table
  514. best way to compile thousands of TSQL stored procedures?
  515. Where do views and SP's execute?
  516. Default base
  517. sp_spaceused
  518. Query Help, thanks!
  519. getting english column names into a german database
  520. Can't register local instance of SQL Server on local server PLUS
  521. Usability Evaluation Study n570
  522. Need help with creating view
  523. SQL Server concatenation error
  524. UPDATE ORDER BY error
  525. DTS Restore from a file
  526. DTS package with unexpected issues
  527. SQL Report/View
  528. Can't register local instance of SQL Server on local server PLUS
  529. Alert on data deletion
  530. data types
  531. Importing .txt to SQL
  532. problem : random error with with IIS6 and MSSQL
  533. SqlServer2000: autonumbering records - how to ?
  534. Asignar a una variable el valor de un campo
  535. How to enable TCP/IP connectons to SqlServer
  536. Ordering, Grouping - HELP!
  537. auto numbering
  538. SQL 2K Backup Log Monitoring
  539. SQL 2005 Integration Services Help
  540. Performance mystery -- SP vs script
  541. Database Restore Woes
  542. SQL Server 2K problem with fractional real values
  543. Query Help, thanks!
  544. Transforming rows into columns
  545. Script to restart replication
  546. How can I find what tables are loaded in memory ?
  547. Windows 2000 Server / IIS / SQL Server 2000
  548. why does a user function require dbo.* and a stored proc does not?
  549. DTS import does not import all rows / records
  550. Table lock